Count based on criteria from two different columns
 

Hello,

I am sure this is a simple formula but for the life of me I can not remember.

Here is my scenario:

Column C (c6:c70) contains the data "won" or "lost"
Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc.

I need to count, in another column, how many backhoes were lost and so on.

Thanks,
Brandy

Count based on criteria from two different columns
 

Try this:

=SUMPRODUCT(--(C6:C70="lost"),--(F6:F70="backhoes"))

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"ba374" wrote in message
...
Hello,

I am sure this is a simple formula but for the life of me I can not
remember.

Here is my scenario:

Column C (c6:c70) contains the data "won" or "lost"
Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc.

I need to count, in another column, how many backhoes were lost and so on.

Thanks,
Brandy

Count based on criteria from two different columns
 

Try this array formula (ctrl-shift-enter):

=COUNT((C6:C70="lost")*(F6:F70="backhoes"))


HTH,
JP

On Nov 13, 11:33 am, ba374 wrote:
Hello,

I am sure this is a simple formula but for the life of me I can not remember.

Here is my scenario:

Column C (c6:c70) contains the data "won" or "lost"
Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc.

I need to count, in another column, how many backhoes were lost and so on.

Thanks,
Brandy