IFSUM

B

Bob_O

When using IFSum I tried to use the location (C6) where I had the name of a
range and the function doesn't work. I also tried to use a location where I
had a date number. I used the less than symbol with the location and again
the function doesn't work.
 
J

Jerry W. Lewis

There is no IFSUM function native to Excel. Are you talking about SUMIF
or a custom function from an add-in?

SUMIF does not support indirect range references. You might be able to
cobble something together using SUMPRODUCT, but have provided too little
information for specific recommendations.

Jerry
 
C

Chip Pearson

SUMIF does not support indirect range references.

I think it does support indirect range references. For example,
if E1 contains the text string A1:A6, the formula
=SUMIF(INDIRECT(E1),"a",B1:B6)
is the same as
=SUMIF(A1:A6,"a",B1:B6)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
J

Jerry W. Lewis

You're right, COUNTIF and SUMIF have such limited formula handling
ability that I just automatically turn to SUMPRODUCT, even though I
didn't need to in this instance.

Jerry
 
Top