Jim, thanks for responding. I don't understand how SUMPRODUCT will help. If
I have in C2:C5, "Blue","Orange","Green","Brown","Slate" and in C10:C50000
all cells are filled with one of these five values, how will SUMPRODUCT help?
What I should have mentioned is that column A is populated with months in
'2007_10' format. I am able to get the SUMIF to work using C2:C5 as
criteria, but what I want to happen is that value to also only include values
within the range of data I have filtered in column A. So if I have column A
filtered to '2007_10', I only want to see values from the sum range for
October. Does that make sense?

Greg

"Jim May" wrote:

the Sumproduct() function will likely solve your problem. see it in help or
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

"Greg Snidow" wrote:

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