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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!