# SUMIF ?

Options
✭✭✭

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

• ✭✭✭✭✭✭
Answer ✓
Options

@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

• ✭✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!