Checking for multiple values

**Cmorgan** · 01-13-2013, 11:30 AM

Evening,

I am using this formula:

=SUMPRODUCT(('FFTA25%'!$U$2:$U$180="5a")*('FFTA25%'!$AC$2:$AC$180="C-"))

This allows me to add up how many time C- is in the column AC, if 5a is in the column U as well.

What I would like to change it to is count how many times C- or C or C+ is in column AC, if 5a is in column U as well.

Any help would be greatly appreciated.

Many thanks

**Pete_UK** · 01-13-2013, 11:36 AM

Try it like this:

=SUMPRODUCT(('FFTA25%'!$U$2:$U$180="5a")*(ISNUMBER(SEARCH("C",'FFTA25%'!$AC$2:$AC$180))))

Hope this helps.

Pete

**Cmorgan** · 01-13-2013, 01:18 PM

Thanks for this, I just now need one more tweak for a different section and I can put this spread sheet to bed

I need to tweak:

=SUMPRODUCT(('FFTA25%'!$U$2:$U$180="5a")*(ISNUMBER(SEARCH("C",'FFTA25%'!$AC$2:$AC$180))))

So that before it counts the C-,C or C+ grade in column AC, it still checks 5a is in U, but ALSO it checks PP is in column F.

Any help would be really appreciated.

Thanks

**Fotis1991** · 01-13-2013, 01:28 PM

As i see that Pete is ofline, does this helps?

=SUMPRODUCT(('FFTA25%'!$U$2:$U$180="5a")*($f$2:$f$180="PP")*(ISNUMBER(SEARCH("C",'FFTA25%'!$AC$2:$AC$180))))