Calculating a sum

BFuller

Hello, I am hoping someone can help me figure out a way to do this formula. The following formula works:

=SUMIF(Part@row, "022-7374-00", [PO Price]@row * [Bal Due]@row)

I'd like to replace the "022-7374-00" 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 "022-7374-00" 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)

jmyzk_cloudsmart_jp

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})