Complex Count/CountIf calc

S

Sarah (OGI)

I need to count only the cells in column K that meet the following criteria:

where the cells in column U = "Yes"
AND
where the cells in column W = the value in cell O3
AND
where the cells in column K = cell B2

Any ideas?
 
P

PCLIVE

This should get your started.
The range is set for rows 1 through 10. Adjusts this as needed.

=SUMPRODUCT(--($U1:$U10="Yes"),--($W1:$W10=$O$3),--($K1:$K10=$B$2))

HTH,
Paul
 
P

Pete_UK

Try this:

=SUMPRODUCT((K1:K100=B2)*(U1:U100="Yes")*(W1:W100=O3))

Adjust the ranges to suit your data.

Hope this helps.

Pete
 
V

Vergel Adriano

Sarah,

try something like this

=SUMPRODUCT((U4:U10="Yes")*(W4:W10=O3)*(K4:K10=B2))
 
Top