PDA

View Full Version : Solved: Excel formula needed for if or countif or both



Spratt_Cary
07-31-2009, 10:31 AM
How would I write this statement?

if column AF6:AF200 = true for "CRA" then count the number of times the word "*Not*" appears in column AO6:AO200

:banghead: Brenda is banging her head again.

Bob Phillips
07-31-2009, 10:44 AM
Try

=SUMPRODUCT(--(AF6:AF200="CRA"),--(ISNUMBER(SEARCH("Not",AO6:AO200))))

Spratt_Cary
07-31-2009, 11:59 AM
Perfect, can I have some of your brain cells, please.

Bob Phillips
07-31-2009, 12:11 PM
You're joking, they are disappearing fast enough as it is :(