SUMIF ?

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")

Tags:

Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓

    @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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!