 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007testing while suming
I have two columns of data as follows 1 teama 2 teamb 3 teamc 4 teama 5 teamb 6 teamc The number of rows will not change. I'm trying to sum the value that is associated with each team name. Can anyone point me in the right direction? Try this: =SUMIF(B1:B6,"teama",A1:A6) If you want to list your teams in a range somewhere, eg D1:D3, then you can put this variation in E1 and copy into E2 and E3: =SUMIF(B$1B$6,D1,A$1:A$6) Hope this helps. Pete On Aug 14, 4:30 pm, angryelvis <angryel...@discussions.microsoft.com> wrote: > I have two columns of data as follows > 1 teama [quoted text clipped - 8 lines] > I'm trying to sum the value that is associated with each team name. Can > anyone point me in the right direction? SUMIF should work in this case =SUMIF(B1:B6,"teama",A1:A6) would return 5 Just change the "teamL" part of the formula for different teams. > I have two columns of data as follows > 1 teama [quoted text clipped - 8 lines] > I'm trying to sum the value that is associated with each team name. Can > anyone point me in the right direction? Thanks for the answer. I'll spend more time in Help in the future.... > SUMIF should work in this case > [quoted text clipped - 14 lines] > > I'm trying to sum the value that is associated with each team name. Can > > anyone point me in the right direction?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.