Hi,

Try as I might I can't make this formula produce a NUM# error and it works
perfectly comparing text in 2 columns. Did you use the formula I gave you or
did you modify it. What precisly do you have in these 2 ranges? post some
sample data.

Mike

"sajid" wrote:


Hi

It gives a NUM# error. may be because both columns have text entries to
compare

any other solution??

thanks

sajid

"Mike H" wrote:

Hi,

Try this

=SUMPRODUCT((A1:A30=C1)*(B1:B30="Approved"))

Where
Column A = factory names
Column B= Status
C1 = Factory you are trying to count for.

Mike

"sajid" wrote:

Hi Ronaldo

thanks for your reply. is there anyway that i could do this from formulars?

thanks

sajid

"RonaldoOneNil" wrote:

Create a pivot table with the factory name as the row heading, Approved and
Rejected as the column headings and the count of Approved or Rejected as the
value.

"sajid" wrote:

Hi

I have an excel sheet with few columns. one column contain factory names.
the factory name repeats. another column contains the status which can be
either "Approved" or "Rejected". I need to count how many times does a
factory got approved status.


please help on which formula can capture these simultaneous entries.

thanks

Sajid