SUMIFS and referencing columns on another sheet
I've been searching the community and couldn't find an answer so hoping someone will see this and help..
I have a data sheet and am creating a calc sheet for a report. I want to look at the reference sheet, identify one "type" and then sum all the $ for that one type. I have tried different SUMIF/SUMIFS and I cannot figure out what I'm doing wrong. Here is an example of dummy data from the reference sheet (RefSheet1). I want the sum of profits for only pens.
Answers

@MsMaryannM Not sure where you want to put the result, but this should get you most of the way there:
=IF([Product Type]@row <> "", (SUMIF([Product Type]:[Product Type], =[Product Type]@row, Profit:Profit)), "")
If you put that into a column as a column formula, you end up with what I called "Running Profit per Type" that repeats the same value whenever it encounters the product type.
dm

Thanks @Dale Murphy I am looking to use the function/formula it in a separate sheet that I have for only calculations. So the function/formula would be referencing my data sheet and pull in the result to my calc sheet.

@MsMaryannM Cool. The formula shouldn't have to change except that the range references to a remote sheet need to be reconstructed.
dm
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!