SUMIF across a range
I'm trying to use SUMIF to sum the total of all rows that meet a specific criteria
- =SUMIF([SERVICE TYPE]:[SERVICE TYPE], "Monthly Charge", [2017-12]:[2018-01])
This however returns #INCORRECT ARGUMENT. Not sure what I am doing wrong. Any suggestions would be most appreciated.