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?