Hello,
I have a sumif formula that is accumulating figures for a production week. On the attached sheet, page test2 shows the example.
Column F shows the total figures per week. What I would like the formula to do is look at column C as well, and where it says APR delete the figure from the total requirement.
For example, on the sheet, week 48 shows a grand total of 2524.59 required but one of the orders is an APR. Therefore I'd like it to take away the 1975.9 in column B that refers to that APR, leaving 548.69.
Is anything like that possible?
Thanks
Bookmarks