Good morning,
Looking to use an absolute reference to lock certain cells into a sumif formula. Please see below for current code:
I am needing to lock in the row numbers for the criteria and sum range. Any help is appreciated. Currently the above formula returns this within the spreadsheet:Please Login or Register to view this content.
=SUMIF($P2:P3217,S2,$H$2:$M3217)
I am needing it to be the following:
=SUMIF($P$2:$P$3217,S2,$H$2:$M$3217)
Thanks.
Bookmarks