Count Function help required

K

KSteven

Hi,

I have a spreadsheet of data, and am currently creating tables at th
top for and easy overview. I have done some basic countif statements
however I need to create one that counts 1 record when it meets
criteria in different columns for example...

I need to count column B if data matches "AA" and in the same ro
column F = "BB" If columns B and F match my criteria than I want it t
count as 1 else 0.

Hopefully this makes sense !! :confused
 
B

Bob Phillips

=sumproduct(--(b1:B1000="AA),--(F1:F1000="BB"))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top