SUMIF alternative
Also,
you can use arrary formula (sum with if)
sum(if((col1="a")*(col2="b"),sum_range,0))
enter with cntl+shift+entter
On Thursday, 7 July 2016 03:19:06 UTC+5:30, Dave H wrote:
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
--
Dave H
|