```Hello all.

work for me.

My worksheets contain the contribution for each person for one day out
of the week.  One issue I have is that all my worksheets have the date
for the worksheet name (it is easier to see what a person contributed on
a certain day if the date is immediately visible on the tabs).

I want to sum all the contributions for each person over the course of
about 6 months.   There are about 70+ people, and I want to show what
each person contributed totally.  Is there a way to do this using the
SUM formula?

I don't think this would be a conditional sum, unless I have to account
for blank cells outside the range of names and totals.

Thanks.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
```
 0
dhousto6 (10)
9/8/2004 10:23:59 PM
excel 39879 articles. 2 followers.

1 Replies
641 Views

Similar Articles

[PageSpeed] 58

```Is each person's name in the same location on each sheet?

If yes, say your info that you want to sum is in E19 of each sheet.

I'd add two sheets--one to the far left named Start and one to the far left
named Finish.

Then make sure your summary sheet is not between the Start/Finish worksheets.

Then you can use:
=sum(start:finish!e19)

Dimetric Houston wrote:
>
> Hello all.
>
> work for me.
>
> My worksheets contain the contribution for each person for one day out
> of the week.  One issue I have is that all my worksheets have the date
> for the worksheet name (it is easier to see what a person contributed on
> a certain day if the date is immediately visible on the tabs).
>
> I want to sum all the contributions for each person over the course of
> about 6 months.   There are about 70+ people, and I want to show what
> each person contributed totally.  Is there a way to do this using the
> SUM formula?
>
> I don't think this would be a conditional sum, unless I have to account
> for blank cells outside the range of names and totals.
>
> Thanks.
>
> ** Posted via: http://www.ozgrid.com
> Excel Templates, Training, Add-ins & Software!
> http://www.ozgrid.com/Services/excel-software-categories.htm **

--

Dave Peterson
ec35720@msn.com
```
 0
ec35720 (10082)
9/9/2004 12:36:35 AM

Similar Artilces:

Macros for worksheet copy & paste?
I have 6 different excel files. How can I combine all 6 of them in one single excel file under individual worksheets (E.g. Worksheet1 for File1, worksheet2 for File2 ....etc)? I do not wish to copy & paste it manually. Can I use a macro to take care of it? If so, where can I find further info on how to go about it? THANKS!! Assuming (1) this is a one-time need, and (2) your workbooks have only one sheet each, this would probably be faster done by hand: 1) With all the files open choose one of the files to be the receiving file. 2) Select the sheet in the subsequent books, one at...

NESTED IF STATEMENTS #2
Having a little problem in an excel class, hoping someone might be able to help. I'm trying to fill in the discount column on a spreadsheet with the following info. The problem states use a nested form of the IF function to calculate 15% if Amount is greater that \$300., 10% if Amount is greater than \$100., and 0% if Amount is less than \$100. The Amount column is cell D5. Anyone know how to write the formula and explain how to go about it? Any help would be much appreciated. Let's see. This is homework so you should come up with the answer yourself. Did you start by looking in the he...

How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5- E5. I have several lines of text in the cells and I want them to wrap across the merged cells and it is not working. All I get is the first line of text showing and the rest is cut off. It works if the cells are not merged, but I really need to do it in my merged cells. Is there a way to this other than manually resizing the height of the row? Instead of merging cells, have you tried the "Center Across Selection" option ? The appearence is just about identical to what you would get using merged cells, although I d...

Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two different .pst files (one for my work stuff and one for home) on the same computer. Is it possible to do this? If so, can I can I configure one of the pst files to get e-mail from one account, while the other pst file is configured to get mail from the other account? Thanks! -D Yes, you can create multiple PSTs. I keep mine stored in the same file location but with different names. Depending on which version of Outlook you run, you can creat a new pst from file/new/Outlook Data File (I run Outlook 2003 but had multiple P...

HELP!!! The main menu bar is missing off my excel sheet and I can't seem to find anyone to help me get it back. The menu I am missing is the one that includes - File, Edit, Insert and etc. I have tried...right clicking - customize - toolbars, but I don't seem to have the needed item. Anyone with suggestions - please reply... Thanks. Hi if you right-click on the menu bar you should see an item like 'General'. Check this item -- Regards Frank Kabel Frankfurt, Germany JoEllen OSBDC wrote: > HELP!!! The main menu bar is missing off my excel sheet > and I can't s...

Embedding worksheet into Word
Has anyone had the experience where when they embed a worksheet into Microsoft Word, a portion of the worksheet gets cut off? Is there an easy fix to this? ...

SUMIF function not calculating from closed worksheet

excel, worksheet, set print area, position selection on printed pa
Office 07, Excel. Print area is set, print preview displays selection, always on far left of page. I want to choose the position on the page, eg centered or right aligned etc. Help please. Hi, To get your printout to center on the page chose Page Layout, click the Page Setup quick launch button (bottom right corner of the Page Setup group). Choose the Margins tab, click Horizontal. There is no command to right align a printout, but you can change the left margin to force the printout to the left. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Eve Al...

Hello all I have a 2 sites which users come and go from. These sites have 2 different network ip domains (192.168.1.x and 192.168.2.x). Users need to be authenticated using the same user id and password at both sites. DC/GC is at 192.168.1.x and is a SBS 2003. Server at 192.168.2.x is Server 2003. When the server at 192.168.2.x is connected via vpn to 192.168.1.x all is well. How do I get the server at 192.168.2.x to act as a AD/DC when itâ€™s not connected to 192.168.1.x ? Thank you Hal I think you will run here into the limitations of SBS :-( @ SBS experts : ...

Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 12.0.0.1 on Leopard 10.5.2, all updates applied to both. A friend is migrating from Windows to Mac, and has come across something that we're trying to work around. He has some .ppt files with font glyphs in from a Unicode .ttf font (a specific purpose font for showing the LCD display characters on a piece of monitoring equipment). When we bring the font and .ppt over to the Mac, the glyphs from the normal ASCII range come over into Powerpoint 2008 fine, but the glyphs from the "private use" range from F000 upwards a way don't transfer. In Powerpoint they show as spac...

using dates Part 2
Karl was great in helping me get to this point with dates, now I'm wondering if we can take it 1 step further? For Activity Dates prior to 2/1/2007 they are using a normal reporting year and the formulas below take care of Activity dates >2/1/2007? So for example prior to 2/1/2007 1/1/2006 would have a B_Qtr of 2006-1 1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q") 2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate])) 3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q") -- Than...

Send 1 address to 2 mailboxes

Creating a worksheet in Spanish
Hello, Is there a way to create a worksheet on MS XP Pro running Office 2003 Pro all in Spanish? Thank You Kent Hansen Hi Kent All valid formulas -except the ones from the Analysis Toolpack- will automatically translate to the language of the Excel it's opened in. So any spanish speaking Excel will translate formulas to spanish, no matter which version it was written in. The rest, text constants and such, has to be typed or pasted. Excel will not translate this herself. HTH. Best wishes Harald "Kent" <Kent@discussions.microsoft.com> skrev i melding news:ACCCBA3A-53B4...

Publisher 2000? #2
Is there a place where I can still get version 2000? I've been looking, but all I can find are updates and the 2007 trial. My computer can't run 2007. *If* if can be had, try something like eBay. (I wouldn't buy software that way but that's just my preference.) You may find you have better luck finding a leftover copy of Pub 2003 from some online retailers. (I actually prefer that over 2000.) -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Jason" <Jason@discussions.microsoft.com> wrote in me...

Compare 2 different workbooks with the result in a 3rd
I have two workbooks (2005 Sales, 2004 Sales), which track daily results in half hour intervals. I want to be able to show the increase in 2005 in a 3rd workbooks. The first two workbooks are identically formatted. How can I do this? Many thanks to all in the forum who have helped in the past. If the data is in exactly the same position in the two worksheets you could copy/paste one's data to a new worksheet and then copy the second's, doing an Edit, Paste Special, Subtract on top of the first's data. This is admittedly crude but it is easy to do. -- Jim Rech Excel MVP &q...

How do I combine two worksheets into one graph
I have two worksheets on an Excel spreadsheet. I would like to take both worksheets and place in one graph. Any suggestions? Make a chart with data from one sheet. Then copy the data on the other sheet, select the chart, and use Paste Special from the Edit menu to add the copied data as New Series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ McPowerUser wrote: > I have two worksheets on an Excel spreadsheet. I would like to take both > worksheets and place in one graph. Any suggestions? ...

import from eudora #2
I have used Eudora for many years, but am planning to set up my email in outlook. I want to move all of my mailboxes to outlook. Eudora does not have an export function. Do I need to go through something else, such as Thunderbird. I can't use Outlook Express, because it only imports through Eudora v3.0. I have 4.3. Any thoughts on this? "Nate Rosenthal" <ncrose@comcast.net> wrote in message news:IOmdnV5bH5fEddbVnZ2dnUVZ_rbinZ2d@comcast.com... >I have used Eudora for many years, but am planning to set up my email in >outlook. I want to move all of my m...

Macro on a protected worksheet in a shared workbook.
Hi, I have a macro in protected worksheets that can't run once the Workbook is Shared. I have wrapped the Macro code so as the worksheet is unprotected for the time the Macro runs, and unable the Autofilter. The code is as follow at the moment: Sub Newaction() Sheets("Critical Path").Unprotect ("") ' Newaction Macro ' Macro recorded 17/11/2004 by Clifford ' ' Selection.AutoFilter Field:=1, Criteria1:="=" Sheets("Critical Path").EnableAutoFilter = True Sheets("Critical Path").Protect contents:=True, userInter...

Excel AutoSave #2
In Excel 2000 was this feature available? User is not seeing it. Excel 2000 had the AUTOSAVE.XLA Add-in Should be in Tools>Add-ins. If not available there, do a file search on your computer. If not there, install from the CD. Gord Dibben Excel MVP On Thu, 6 May 2004 13:26:16 -0700, "Ssolano" <anonymous@discussions.microsoft.com> wrote: >In Excel 2000 was this feature available? >User is not seeing it. ...