I need your help with merging the sumif and the subtotal function.
But not in the way which most posts in forums are about. This is NOT about filters...
What I want to do is the following. I would like to use a normal sumif function with criteria in another column than the sumrange. The problem is, that there are some subtotals in the sumrange which I do not want to be added to the sum. Some of these Subtotal rows have valid values in the criteria_range. So they would be double counted.
I tried to replace the criteria in the sumifs by a IF function and have the subtotal function as the "true value" but this doesn't work:
IF(criteria_range = "name", SUBTOTAL(9, sum_range))
Thanks for your help!
But not in the way which most posts in forums are about. This is NOT about filters...
What I want to do is the following. I would like to use a normal sumif function with criteria in another column than the sumrange. The problem is, that there are some subtotals in the sumrange which I do not want to be added to the sum. Some of these Subtotal rows have valid values in the criteria_range. So they would be double counted.
I tried to replace the criteria in the sumifs by a IF function and have the subtotal function as the "true value" but this doesn't work:
IF(criteria_range = "name", SUBTOTAL(9, sum_range))
Thanks for your help!
