MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Aladin


Posted by Brian on January 16, 2002 10:51 PM

Aloha Again Aladin,

Sorry for all the trouble. I'm confused as to the two formulas you gave me. The first and second ones both work when I enter employee name in both B and G.
Why is that. Here are the formulas:

=SUMIF('[VACATION CALENDAR.xls]JAN.'!$A$1:$H$100,"Donna Fukuhara",'[VACATION CALENDAR.xls]JAN.'!$B$1:$B$100)

Here is the second:

=SUMIF('[VACATION CALENDAR.xls]JAN.'!$B$1:$B$100,"James Garcia",'[VACATION CALENDAR.xls]JAN.'!$C$1:$C$100)+SUMIF('[VACATION CALENDAR.xls]JAN.'!$G$1:$G$100,"James Garcia",'[VACATION CALENDAR.xls]JAN.'!$H$1:$H$100)

How can I also add all the months that are in different worksheets labeled Jan Feb etc.

Thanks a load your kind help!

Brian


Posted by Aladin Akyurek on January 17, 2002 1:07 PM

Aloha Brian,

It's weird that you get a total at all with the first formula when "Donna Fukuhara" is in B and her vacation hours in C. Maybe I should have a look at your workbooks!

> How can I also add all the months that are in different worksheets labeled Jan Feb etc.

You mean summing up vacations hours thru all month sheets?

3D refs cannot be built with SUMIF. You have to use SUMIF per month sheet in your summary sheet and total the totals in the summary sheet to get the whole picture, I'm afraid.

Aladin

=======