Complex Count/CountIf calc

[Guest]

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?

 

[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

 

[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

 

[Guest]

Sarah,

try something like this

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