Formula Help

**JazzyZ78** · 07-14-2011, 03:38 PM

I am looking to write a formula in the "Data" tab of my spreadsheet (attached) beside the associated team name in column B that looks at "Sheet1" and references column E and F and returns the total points a team has.

So for example if Sheldon has 5 players in the Top 100 it would add up the points in column F and return that number back to the "Data" tab in column B beside the associated team.

Hope that makes sense.....Any help would be greatly appreciated.

**daddylonglegs** · 07-14-2011, 03:50 PM

Try using SUMIF, i.e. use this formula in B1 copied down

=IF(A1="","",SUMIF(Sheet1!E:E,A1,Sheet1!F:F))

**JazzyZ78** · 07-14-2011, 03:56 PM

I copied it in and didn't seem to get the right numbers? Some even had 0.

**daddylonglegs** · 07-14-2011, 04:04 PM

It works for me but the spelling needs to be consistent, e.g. "Shelton" should be "Sheldon"?

**NBVC** · 07-14-2011, 04:04 PM

You might want to update your thread title according to our rules too... See Rule 1 (link in my signature).

**JazzyZ78** · 07-15-2011, 08:19 AM

How do I mark this as Solved?

Also thanks daddylonglegs....you were right I had the name wrong. Awesome job!

**NBVC** · 07-15-2011, 08:22 AM

First, please update your title, then try

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save