Total from Another Sheet
Hello I am trying to say if the PO number on Sheet One matches the PO number on Sheet Two, to pull the total of invoices from Sheet Two.
Thank you in advance!
Answers
-
Hi @Alexsys -
I think you will want to use a SUMIF/SUMIFS formula to pull this over. I would also review Smartsheet's article on cross-sheet formulas to see how to set ranges if needed!
Information below:
SUMIF function: https://help.smartsheet.com/function/sumif
SUMIFS function: https://help.smartsheet.com/function/sumifs
Create cross-sheet formulas: https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas
-
Hi @Antonie B ,
I got the formula to work. Basically I need total $ amount from invoices pulled from my PO sheet, which I achieved with the formula, but, I also need total $ amount from cc charges pulled from another sheet now. Ideally I would like to pull the total from each sheet and have them added together. Any ideas? Please see my formula below (this is before trying to add cc total).
=SUMIF({US Payment request Range 1}, =[PO Number]@row, {US Payment request Range 2})
-
Hey @AlexysR -
Gotcha there is two ways you can do this, either you pull the totals into their columns and then add them together on the sheet in a 3rd column using =cell1+cell2 or you can combine them like so =SUMIFS(formula 1) + SUMIFS(formula2).
In terms of the formula you used above, you are very close, just need to remove the 2nd "=" like this: =SUMIF({US Payment request Range 1}, [PO Number]@row, {US Payment request Range 2})
Does that help?
-
@Antonie B Hi Antonie,
Oh didn't know it would be that simple to do, got it. It seems to still work with the = sign in there. The sheet you had originally shared with me it said you could use an = sign. Thank you for all the help!
-
@Alexsys -
To your point, you could use it, but with COUNTIF/SUMIF formulae that is the default operator it uses so it will save you adding this each time.
The "=" would more be used as i.e. IF(Colour@row = "Green", or COUNTIF(Year:Year, YEAR(@cell) = 2024
Happy you got it to work however!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!