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.
I decided on LET but my phone keeps saying "There's a problem with this formula."
https://1drv.ms/x/s!AqSkT5cvQtioryF-mGEhgNa6pDAw
Here's the url to my OneDrive file. I have completely rewritten this in excel vs copy and paste so shouldn't be any invalid characters.
What am I doing wrong?
Edit: I wrote an apostrophe in front of the formula so I can show you.
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. 😁
