Forum Discussion
Sumifs giving wrong result
Hi
I have data, where I wanted to sum if amount falls between date range and spent from specific bank. I have used Sumifs formula, out of 12 incidences, 10 times the formula worked wrong as I checked by filtering the data.
I can't seem to find why it has worked on those 2 incidences.
I would be grateful if someone can look into it.
I can't see any option available to attach excel file, so I am sending Google drive link. I hope you will be able to see this. Formula in question is in cell O2198 to O2209
https://docs.google.com/spreadsheets/d/1D0ICqSqIi2d6m-ihStm5nC8TjLFAnPOv/edit?usp=drive_link&ouid=105560721065247909214&rtpof=true&sd=true
https://docs.google.com/spreadsheets/d/1D0ICqSqIi2d6m-ihStm5nC8TjLFAnPOv/edit?usp=drive_link&ouid=105560721065247909214&rtpof=true&sd=true