Forum Discussion
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.
Several things.
- The data on the second sheet needs to be formatted as Table (Format as Table from the Home tab)
- There is a trailing space after "Description" on the second tab
- The formula has a couple of closing parentheses in the wrong place, I fixed those for the yellow cell.
- The data on the second sheet needs to be formatted as Table (Format as Table from the Home tab)
- There is a trailing space after "Description" on the second tab
- The formula has a couple of closing parentheses in the wrong place, I fixed those for the yellow cell.
Thank you so much for the reply and now I know for future projects. Cheers. 😁
