SUMIF ?

jelfner

Can someone help with the correct formula for the following: I need the JO Volume column sum if the PO Forecast Month column is marked 01-January. Below is what I have so far, but it is not working. I appreciate the help - thank you!

=SUMIF([JO Volume]1:[JO Volume]40, [PO Forecast Month]1:[PO Forecast Month]40, "01-January")

JamesB

@jelfner Your formula for a SUMIF is out of order.

for SUMIF, it is RANGE, CRITERIA, SUM_RANGE

Try this...

=SUMIF([PO Forecast Month]1:[PO Forecast Month]40, "01-January",[JO Volume]1:[JO Volume]40)

JamesB

@jelfner Your formula for a SUMIF is out of order.

for SUMIF, it is RANGE, CRITERIA, SUM_RANGE

Try this...

=SUMIF([PO Forecast Month]1:[PO Forecast Month]40, "01-January",[JO Volume]1:[JO Volume]40)

jelfner

Thank you so much! That worked perfectly. I really appreciate your quick help!!!