Count using multuple criteria

  • Thread starter Thread starter readystate
  • Start date Start date
R

readystate

I have a spreadsheet where column B is a drop down box with two choices - NEW
or EXISTING. I need to count the number of times that the word NEW appears
in column B if column J is equal to specific criteria, ex, CLOSED. Please
help me with this formula. Thanks.
 
Try something like this:

=SUMPRODUCT((B1:B30="New")*(J1:J30="Closed"))

Adjust range references to suit your situation.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Worked fine...thanks.

Ron Coderre said:
Try something like this:

=SUMPRODUCT((B1:B30="New")*(J1:J30="Closed"))

Adjust range references to suit your situation.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
I'm glad I could help......Thanks for the feedback.

***********
Regards,
Ron

XL2003, WinXP
 
Back
Top