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;
Any help you can give is much appreciated......



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

You must use amoersand:



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

Awesome Aladin! Thank you very much!