Can I get around SUMIF's rigid criteria without using DSUMs

[jedi160]

I wanted to put a cell reference as the criteria in a SUMIF function, when I remembered that SUMIF only lets you use numbers, expressions, or text. But is there a way to get it to recognize and update cell references, or is there possibly an add-in that would allow this?

 

[Aladin Akyurek]

Not sure what you are getting at... SumIf admits cells as criteria like in:

=SUMIF(CondRange,">="&X2,SumRange)

where X2 houses a criterion that must hold for CondRange.

 

[jedi160]

I'm an idiot

Don't worry, I'm an idiot. I saw what I was doing wrong.

Thanks.