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