Formulas =SUMIF

kane.godfrey
kane.godfrey ✭✭
edited 12/09/19 in Formulas and Functions

Hi, 

I need help to solve this puzzle. I'm using this sumif formula  

=SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value})

to sum up the total value of invoices against a particular order number. 

I've checked that all columns are formatted as text. See snap shot of actual formula attached. 

Cheers 

Kane 

_17__0114_BD_Signage_Accounts_Cost_Record_-_Smartsheet_com.png

_17__Supplier_Invoice_register_-_Smartsheet_com.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!