Forum Discussion
Solved
How to sumif for multiple criteria in a single column?
As an example. I want to sum everything in D column for this financial year with the Description of "Taxi" and "Cash" =SUMIFS(Data!D:D,Data!A:A,">="& DATE(YEAR(TODAY()),7,1),Data!A:A...
ChrisTheWizard The screenshot suggests that you are on using the mobile version of Excel. Then the attached example, created on the desktop, should work for you as well.
No doubt, other will contribute alternative solutions.
ChrisTheWizard The screenshot suggests that you are on using the mobile version of Excel. Then the attached example, created on the desktop, should work for you as well.
No doubt, other will contribute alternative solutions.
Marked as best response because most efficient method for this thread. I'm sure many others will find it useful 👍