• ## 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
Step 1 – Register, Activate Your Account and Log In
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

It can also be done with COUNTIFS

=COUNTIFS(G4:G20,"*IC*",G5:G21,"STAT")

A bit neater.
...

Bob Phillips Today, 11:39 AM

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

Aah, I thought the text was all in one cell, it is separate cells.

Try this

=SUMPRODUCT(--(ISNUMBER(FIND("IC",G4:G20))),--(G5:G21"STAT"))...

Bob Phillips Today, 12:03 AM

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

Hi Bob,

I have taken a snippet out of my larger spreadsheet and attached it. You can see the two 4's below the table are where I inputted...

VSM Yesterday, 10:37 PM

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

Muchas Gracias me ha sido de gran ayuda...

Josue Alba Yesterday, 07:59 PM

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

Buenos días. Lo sentimos, no es posible incluirlos en la consulta. Así no es como funciona Power Query. La autenticación se administra en la máquina...

Ken Puls Yesterday, 07:42 PM