View Single Post
  #1   Report Post  
Dave H Dave H is offline
Member
 
Posts: 54
Default 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