Count the In Process jobs

Hi,

I would like to count the No. of jobs In Progress.

Excel file attached with necessary details.

Pl. help.

Thanks,
Nagesh.

Wow! Great.

Moreover, How can I get the answer if I don't have "Completed" column.

Grateful if I can get that too.

Thanks,
Nagesh.

Try

=SUMPRODUCT(--($D$2:$D$30<>"")*($B$2:$B$30<>$D$2:$D$30))

Great!

Both are working.

Thanks Tony and John.