Complex Count/CountIf calc
 

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?

Complex Count/CountIf calc
 

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


"Sarah (OGI)" wrote in message
...
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?

Complex Count/CountIf calc
 

Try this:

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

Adjust the ranges to suit your data.

Hope this helps.

Pete

On May 1, 3:19 pm, Sarah (OGI) wrote:
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?

Complex Count/CountIf calc
 

Sarah,

try something like this

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



--
Hope that helps.

Vergel Adriano


"Sarah (OGI)" wrote:

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?