probably a simple question

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
 
A

Arvi Laanemets

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compute Additional Hours Needed Using "if" or "lookup" 1
Standar deviation across sheets help 0
Simple COUNTIF function help 3
use month in cell date to sum all relevant cells 2
Vlookup doesn't work: results are wrong 2
VLookup Function HELP 7
Counting unique values based on 2 columns 3
Counting question 16

Top