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.

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

Bob_O wrote:

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.

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



"Jerry W. Lewis" wrote in message
...
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

Bob_O wrote:

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.

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

Chip Pearson wrote:

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)