Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning text; alternative to sumproduct/sumif? | Excel Worksheet Functions | |||
Sumif or Better Alternative? | Excel Worksheet Functions | |||
alternative function to sumif | Excel Discussion (Misc queries) | |||
SUMIF Alternative? | Excel Worksheet Functions | |||
SUMIF Alternative? | Excel Discussion (Misc queries) |