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

Issues with SUMIFS function

Hey there, I'm working in a basic PoS spreadsheet for my business and I'm having problems when I tried to apply the same function but with different condition. In first picture the function works with the condition "Efectivo" but when change it to "Yape" (as you see in the second picture) the function give me a wrong result. The third picture shows the sum-values and test-values. I don't know why it can't work with the condition "Yape" if I typed it in the right way.

MacBook Air (M1, 2020)

Posted on Jan 17, 2024 7:51 AM

Reply
3 replies
Sort By: 

Jan 17, 2024 2:35 PM in response to Cranmer_CS

Yeah, a different time will do that.


Assuming A3 is the date at 12:00AM, with SUMIFS you can sum all values for the day by using the two conditions ">="&A3 and "<"&A3+1. That is everything greater than or equal to the specified date at 12:00AM and less than 12:00AM the next day. If A3 is not at 12:00AM, replace A3 with DATEVALUE(A3) which strips the time from it.

Reply

Issues with SUMIFS function

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