SumIfs based on Multiple criteria

Trying to sum up an amount based on 2 criteria's. i'm getting $0.0

Find more posts tagged with

Accepted answers

This formula worked

=SUMIFS({Retainer/Deposit Forcasting Range 1}, {Retainer/Deposit Forcasting Range 3}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2023), {Retain/Dep Range 3}, "Deposit") + SUMIFS({Retainer/Deposit Forcasting Range 1}, {Retainer/Deposit Forcasting Range 3}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2023), {Retain/Dep Range 3}, "Retainer")

All comments

ginamt3

I figured it out. No need to reply:)

Leibel S

@ginamt3

Can you post an example of the data? (what each range has)

Formula seems good...

ginamt3

This formula worked

Leibel S

@ginamt3

You can simplify using the OR function on your Range 3

ginamt3

@Leibel S Thank you that works in a new sheet that I created.

How would I pull from an additional sheet but only want to include "un checked" Hide retained job column?

Screenshot 2023-12-22 at 1.28.30 PM.png

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.