Re: SUMIF Totals based on multiple critertia
forum.ozgrid.com/index.php?attachment/69911/
Hello NBVC, can I bug you again. I have another one I can't quite figure out. Attached is the sample. There are 2 worksheets.
On the Summary tab, I want Column N to return the value from Column R on the Detail tab, if the month in column C (summary sheet) and month in column K (detail sheet) match AND if the UIC in column A (summary sheet) and the UIC in column T (detail sheet) match. Does that make sense?
Also, to add a step further, could I have Column H on the summary tab, count the Qty Shipped from the detail tab, based on if there is a date or if it's blank? Same with the Qty Handed off, count how many have a date or not, still matching the above criteria?
If it's way confusing, please disregard. I am trying automate so things for my employer, as I will be leaving this office in Oct.
THANK YOU FOR ANY HELP YOU CAN OFFER! What you have done for me so far has already proved invaluable!!!