Total from Another Sheet

Alexsys

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!

Antonie B

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

Alexsys

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

Antonie B

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?

Alexsys

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

Antonie B

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