SUMIFS and Sheet Summary Date

Hello all,

I am wondering if it is possible to use the date in a sheet summary to pull all data for a specific date.

I have a current formula that looks like this:

=SUMIFS(Payed:Payed, Date:Date, Date#, Denomination:Denomination, ="$0.01")

The formula is looking through Date:Date to find dates that match Date#, which is the sheet summary date. I am trying to get this formula to return the sum of Payed for rows where Date# and $0.01 are true, but this returns $0.00 even though I know for sure that there are rows where Date# and $0.01 are true.

Thanks in advance.

Find more posts tagged with

Accepted answers

Rylan Funk

Thank you so much for replying Andree, but I just figured out my problem. The "$" in $0.01 did not work for some reason. So, I removed it and now it works.

All comments

Andrée Starå

Hi @Rylan Funk

It is. I use it all the time.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rylan Funk

Thank you so much for replying Andree, but I just figured out my problem. The "$" in $0.01 did not work for some reason. So, I removed it and now it works.

Andrée Starå

@Rylan Funk

Glad that you got it working!

You're more than welcome!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.