On Mar 7, 12:45 pm, "sabbathnut" wrote:
Hello

How would i go about counting the toal number of jobs still "running"
by different area

Colum A has several business area'a In Colum B has the job ref number
Colum C has the status running, not started, Complete

how do i do the formula to count how many jobs for "area 1" are not
started??

Cheers

=SUMPRODUCT((A1:A100="area 1")*(C1:C100="running"))

HTH
Kostis Vezerides