Good morning.
I am having trouble finding a solution. I need to sum the sumifs of some data that is in a table. I don't want to convert it to a range. there is only one criteria per column except the last column. There I have multiple criteria to sum together. I usually would use something like:
I am having trouble finding a solution. I need to sum the sumifs of some data that is in a table. I don't want to convert it to a range. there is only one criteria per column except the last column. There I have multiple criteria to sum together. I usually would use something like:
Code:
=sum(sumifs(sum_range,Criteria1_range,criteria1,criteria2_range,{criteria2_A, criteria2_B}))
[\code]
this results in a warning that excel has found a problem with my formula.
For now I am using the work around of:
[code]
=sum(sumifs(sum_range,Criteria1_range,criteria1,criteria2_range,criteria2_A)+sumifs(sum_range,Criteria1_range,criteria1,criteria2_range,criteria2_B)))
[\code]
this works fine, however, I will be needing a sumifs with about 10 criteria in one column. So the work around gets a bit inefficient.
any help would be greatly appreciated.
thanks,