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

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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!!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.