probably a simple question

  • Thread starter Thread starter azlon
  • Start date Start date
A

azlon

i have a database with about 100 entries. i have columns A-Y. in column
O i have 3 different values (either 362, 201, or 275). in column Y i
have 4 different values (either O, W, E, or N). i want to get the total
number of rows that have 362 and E in there. how can i do that? i know
the pseudo code.

countif (O2:O102, "(E) && (362)")

but this doesnt work... what am i doing wrong?

- azlon
 
Hi

=SUMPRODUCT((O2:O102=362)*(Y2:Y102="E"))
or
=SUMPRODUCT((O2:O102=362)*(Y2:Y102="E")*1)
 
Back
Top