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,”<=” & DATE(YEAR(TODAY())+1,6,30),Data! E:E,”Cash”,Data!E:E,”Taxi”)
This returns 0. Is it because I need to add multiple sumifs statements together or am I missing something in my statement?
T
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,”<=” & DATE(YEAR(TODAY())+1,6,30),Data! E:E,”Cash”,Data!E:E,”Taxi”) This returns 0. Is it because I need to add multiple sumifs statements together or am I missing something in my statement? T Read More
