# Total from Another Sheet

Options
✭✭
edited 02/08/24

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!

• ✭✭✭
Options

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

• ✭✭
Options

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

• ✭✭✭
Options

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?

• ✭✭
Options

@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!

• ✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!