• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm that you’re a real person. ...
• ### Recent Forum Posts

#### COUNTIFS and INDEX/MATCH - How to count cells based on cell below it

Try

=COUNTIF(H4:H21,"*IC*")-COUNTIF(H4:H21,"*IC*STAT*")

or

=COUNTIFS(H4:H21,"*IC*",H4:H21,"*IC*STAT*")...

Bob Phillips Today, 12:37 AM

#### COUNTIFS and INDEX/MATCH - How to count cells based on cell below it

Hello,

I am trying to count cells in a range that meet a text criteria. One addition to this is I want to subtract from the count if the...

VSM Today, 12:16 AM

#### Worksheet named from cell

Andy, I am not sure I fully understand that, so let me state it as I see it.

You want the 'To Cover' items to have DV, that was expected,...

Bob Phillips Yesterday, 11:15 PM

#### Poner parÃ¡metros a una consulta nativa desde una celda Excel

Lo que Power Query quiere decir con una "consulta nativa" es cualquier consulta que esté escrita en SQL. La única forma de evitarlo es conectarse...

Ken Puls Yesterday, 09:32 PM

#### Poner parÃ¡metros a una consulta nativa desde una celda Excel

Muchas gracias nuevamente sin Adularlo usted es un maestro
Quisiera saber si la consulta que le envié antes y me ayudo a que funcionara se puede...

Josue Alba Yesterday, 09:06 PM