Calculating a sum
Hello, I am hoping someone can help me figure out a way to do this formula. The following formula works:
=SUMIF(Part@row, "022737400", [PO Price]@row * [Bal Due]@row)
I'd like to replace the "022737400" with a whole column of part numbers on another sheet. If the Part@row matches any of the numbers in my SL Tab column on another sheet, I want it to do the sum. When I replace "022737400" with the column name, I get 0 in columns I know the part number is listed on the SL Tab. Here is that formula. What am I doing wrong?
=SUMIF(Part@row, {SL Tab}, [PO Price]@row * [Bal Due]@row)
Answers

Hi @BFuller
I would add a helper column to calculate [PO Price]@row * [Bal Due]@row, then reference the column range in the SUMIF function.😀
The syntax of the SUMIF function is as follows:
SUMIF( range, criterion, [ sum_range ])
So, the formula should look like this:
=SUMIF({SL Tab}, Part@row, {helper column range})
Help Article Resources
Categories
Check out the Formula Handbook template!