You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: RobbieSnr
RobbieSnr Author
User level: Level 1
83 points

Dealing with dates in SUMIFS

I'm having a problem dealing with dates in SUMIFS.


I have a table that has values shown according to date. I have another table where I want to show the sum of these values for the year ending with a date I have shown in this second table. To help I have added another date for the starting one. If my conditional phrase is in the form 


(Latest Bills::Table 1::A),">20/10/22",(Latest Bills::Table 1::A),"<=20/10/23"

this works OK. However if I try to replace the actual dates with the cells holding them in this second table I can't paste the cells properly into the formula. Perhaps this has something to do with these dates not being treated as a number - all dates are in columns are formatted as a Date & Time. How do I need to deal with this?



Parallels, macOS 10.14

Posted on Oct 20, 2023 9:52 AM

Reply
Question marked as Top-ranking reply
User profile for user: Recycleur
Recycleur
User level: Level 4
1,609 points

Posted on Oct 20, 2023 11:14 AM

The test has to be something like SUMIFS(Latest Bills::Table 1::A,">"&$B$7, Latest Bills::Table 1::A,"<="&$B$8)

where your dates are in B7 and B8 for example. Basically you do a concatenation to obtain a string for the test condition.



View in context

Similar questions

6 replies

Dealing with dates in SUMIFS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up