Count Function help required
 

Hi,

I have a spreadsheet of data, and am currently creating tables at the
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 2
criteria in different columns for example...

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

Hopefully this makes sense !! :confused:


--
KSteven
------------------------------------------------------------------------
KSteven's Profile: http://www.excelforum.com/member.php...o&userid=31401
View this thread: http://www.excelforum.com/showthread...hreadid=510986

Count Function help required
 

=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)

"KSteven" wrote in
message ...

Hi,

I have a spreadsheet of data, and am currently creating tables at the
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 2
criteria in different columns for example...

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

Hopefully this makes sense !! :confused:


--
KSteven
------------------------------------------------------------------------
KSteven's Profile:
http://www.excelforum.com/member.php...o&userid=31401
View this thread: http://www.excelforum.com/showthread...hreadid=510986