I need to look at the $C$2:$C$21 and if any value is Negative or <0, then I do not want to "COUNTIF($D$2:$D$21,"A")"
want to add all the different "Job Grades" for that period in the "Total No. of Jobs" blocks.
I want to show the cancelled orders as well, so simply deleting that order is not my best option.
What would the formula in cell D26 be?
Bookmarks