Archived 2016 Posts

Archived 2016 Posts

Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SumIf across SmartSheets

✭✭
edited 12/09/19 in Archived 2016 Posts

Is there a way to create a sumif formula that references cells on a different sheet.  

If I'm entering the formula on worksheet2 but suming values from worksheet1 column2 if worksheet1 column1 values  match worksheet2 comlumn5 values.

Example:  =Sumif(sheet1!column1:column1,column5,sheet1!column2:column2)

 

I can't figure out, or find, the correct syntax for this.

 

Thanks

 

Tags:

Comments

This discussion has been closed.

Trending Posts