Query (Sumproduct Formula)

[Raghavendra Singh]

Hi,

I am uploading a file,which is a job card of a specific person in a warehouse.He has many tasks to do each task has deadline,need to calculate how many times he has missed the deadline.Please calculate without inserting or using any extra column,I need the answer in a single cell H1.

Thanks!

Raghavendra Singh

 

[NARAYANK991]

Hi ,

See if this is OK.

=SUMPRODUCT(--((($C$2:$G$12) * ($C$1:$G$1 = "actual")) > (($B$2:$F$12) * ($B$1:$F$1 = "plan"))))

Narayan