Issues with SUMIFS function

Question

Level 1

4 points

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

Answer 1

Top-ranking reply

Badunit

Level 7

30,456 points

Jan 17, 2024 8:29 AM in response to Cranmer_CS

The most likely reason is the "Yape" in the Medio De Pago column has a non-visible character (space, tab, etc.) before or after it. It looks properly aligned so it probably has a space after it (which won't affect the center justification).

Reply

Answer 2

Cranmer_CS Author

Level 1

4 points

Jan 17, 2024 8:45 AM in response to Badunit

thanks for your reply, I've just noticed what I did wrong: in the Fecha column of the 3rd picture I input Date+Time and I guess that function sum all the data with the same date+time so it give me a 0 when I apply the function with different condition.

Reply

Answer 3

Badunit

Level 7

30,456 points

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

Similar questions