sumif criteria
 

It looks like the criteria in such a function must be something hard-coded, rather than say $e$4, where $e$4 is a cell in the worksheet.

Is that correct, or is there a way to do it with a cell being part of the criteria?

Thanks!
Dean

sumif criteria
 

Try something like this:

=SUMIF(A1:A100,""&$E$4,B1:B100)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Dean" wrote:

It looks like the criteria in such a function must be something hard-coded, rather than say $e$4, where $e$4 is a cell in the worksheet.

Is that correct, or is there a way to do it with a cell being part of the criteria?

Thanks!
Dean

sumif criteria
 

Wow, it sure seems to! Given the normal formatting options as (poorly?)
described in EXCEL help (32, 32, "32", etc), I'm not sure why this works,
but it sure seems to.

I can't imagine why your approach isn't in their help section. Surely,
there must be a need for using a cell reference pretty often.

Thank you very much.

Dean

"Ron Coderre" wrote in message
...
Try something like this:

=SUMIF(A1:A100,""&$E$4,B1:B100)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Dean" wrote:

It looks like the criteria in such a function must be something
hard-coded, rather than say $e$4, where $e$4 is a cell in the worksheet.

Is that correct, or is there a way to do it with a cell being part of the
criteria?

Thanks!
Dean