I'm using sumproduct to add up all the quantities of jobs in house.
The formula I'm using is in cell O3.
not sure what I'm doing wrong.
I'm asking the formula to look at column I and look for anything equal to 1
Then I'm asking it to look for cells that contain "Qty"
Then I'm asking it to sum all the jobs that are in house.
It keeps giving me a Value error.
Please help.
Thanks in advance.
Bookmarks