MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using cell reference in SUMIF formula


Posted by Tony on January 27, 2001 12:02 AM

I need to SUM all the cells in a range that fall below a specific numerical criteria. SUMIF would seem to be the answer but it does'nt seem to accept a cell address as the criteria;
Example: SUMIF(A1:A4,">160000") I need to do;
SUMIF(A1:A4,">A5")
Any help you can give is much appreciated......

Cheers,

Tony


Posted by Aladin Akyurek on January 27, 2001 1:48 AM


You must use amoersand:

=sumif(a1:a4,">"&a5)

Aladin

Posted by Tony on January 27, 2001 1:25 PM

Awesome Aladin! Thank you very much!