SUBTOTAL in SUMIF formula
C2:C5 Contain the sum_criteria, text data. C10:C50000 has all cells filled
with one of the values from C2:C5.
"Jim May" wrote:
What is in your C2 and your C10:C50000 (what type of data)?
"Greg Snidow" wrote:
Greetings folks. I am trying to use SUMIF with a nested SUBTOTAL function
like so
=SUMIF(C10:C50000,C2,SUBTOTAL(9,D10:D50000)).
I only want the sum_range to sum based on a filter, and thus the SUBTOTAL.
I know this is not possible the way I have it , because it is not working,
but is it possible some other way? If not, does anyone have a suggstion?
Thank you
Greg
|