Hi,
Need help as my Sumif not able to sum the date to month range
Month / Qty
Date Product Qty Delivered Product Jan Feb Mar
2-Jan-15 A 1 1 A =SUMIFS(C3:C7,B3:B7,F3:F7,A3:A7,G2:I2)
15-Jan-15 B 2 Canx B
2-Feb-15 B 3 0
15-Feb-15 A 4 0
15-Jan-15 A 5 0
**If Cell D has Canx, then, it dont count qty.
The result shall be
Month
Product Jan Feb Mar
A 6 4 0
B 0 3 0
Bookmarks