SUMIF alternative
I have a spreadsheet that has 13 columns the first column for an identifier then 12 more columns one for each month. I can add a sum column but my data is based on a query and the number of rows changes constantly. Currently I am using sumif(A:A,"criteria",B:B)+sumif(A:A,"criteria",:C: C)+and so on so that I get all twelve months of data. Is there a better way to do a sumif that sums up all columns of data as opposed to adding 12 sumifs?
Thanks
|