Thread: how do i count the number of times criteria appears in a worksheet

what formula should i use when i have to count the number of times a cell
criteria appears on a spreadsheet, only when another criteria is present.
ie if "1407" appears in cells L3:L450, only count each of those cells if
"1201" appears in column B for the same row

Try:

=SUMPRODUCT(--(L3:L450 = 1407),--(B3:B450 = 1201))

Regards,
Greg


"MarkWatson" wrote:

> what formula should i use when i have to count the number of times a cell
> criteria appears on a spreadsheet, only when another criteria is present.
> ie if "1407" appears in cells L3:L450, only count each of those cells if
> "1201" appears in column B for the same row

Thank you greg, now we can count how many carpenters (1201's) are listed on
company timesheets that work on job Epping Plaza (1407)

much appreciated

"Greg Wilson" wrote:

> Try:
>
> =SUMPRODUCT(--(L3:L450 = 1407),--(B3:B450 = 1201))
>
> Regards,
> Greg
>
>
> "MarkWatson" wrote:
>
> > what formula should i use when i have to count the number of times a cell
> > criteria appears on a spreadsheet, only when another criteria is present.
> > ie if "1407" appears in cells L3:L450, only count each of those cells if
> > "1201" appears in column B for the same row