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!
