SUMIF Help

Fischb0ne

FireShot Capture 2773 - Sheet - MAIN Sales Pipeline - Smartsheet.com - app.smartsheet.com.jpg

I'm trying to create a reference from another sheet to report on estimated sales by sales rep.

Here is what I tried:

=SUMIF([Sales Rep]:[Sales Rep], "JT Phillips", [Estimate Total]:[Estimate Total])

I get the unparsaeble error.

I need to pull this info into another sheet and then pull it into a dashboard. Can someone help me? Is there an easier way?

TIA!!

Paul Newcome

Here is an article with instructions on how to reference another sheet:

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Fischb0ne

Thanks for the fast response!

I wouldn't use the SUMIF in this at all then? Would I use the above formula at all in this situation?

Nick Korna

You would still use SUMIF. You just need to create the cross sheet references to point at the relevant columns for the criteria/total.

Rather than using the name in the formula and having to do each SUMIF individually, you could have your sales reps listed in a column on the sheet and then use this in the formula with an [Column]@row reference.

Fischb0ne

OK this is what I came up with but it's not working.

=SUMIFS({Sheet-Sales Pipeline Range 1}; [Sales Rep]@row, {Sheet-Sales Pipeline Range 1})

What am I missing?

Thank you all for your help!

Paul Newcome

You should have two different ranges. One that has the criteria to filter on and one that has the data to sum. Your syntax is also off, and you should be using just commas or just semicolons (depending on your region) between each section of the function.

Fischb0ne

HAHA. I think this is over my head. Thank you for your help. I'll keep looking for an answer .

Fischb0ne

is this one closer? =SUMIFS({Sheet-Sales Pipeline Range 8}Estimate Total, {Sheet-Sales Pipeline Range 7}Sales Rep@row)

I am really finding this harder than it should be I feel.