Solved Why is sumif function is giving me the wrong answer!

September 29, 2020 at 09:19:49
Specs: Windows 10
On one sheet I have a lookup function getting different figures from another worksheet depending on the date. In another worksheet I'm using the sumif function to total those figures for the year. It works until I manually enter a figure to be summed.

See More: Why is sumif function is giving me the wrong answer!


#1
September 29, 2020 at 11:25:39

Without more information the best I can offer is to look here and see if any of these help:

https://tutorialsforexcel.com/8-mos...

and since your using Dates, are you sure they are being recognized by Excel as Dates
not Text string that looks like a dates?

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
September 29, 2020 at 14:55:51
✔ Best Answer
I figured it out. My text looked the same but was different somehow. When I copied and pasted the text that was working, it worked out. Thanks for your time.

message edited by lewolfe


Reply ↓  Report •
Related Solutions


Ask Question