Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIf
I have a worksheet titled lost days that look like this:
A B C D 1 Name 96-97 97-98 98-99 2 Bert 3 oscar 4 elmo 5 elmo 6 maria Then a 96-97 worksheet (i have one for each year begining 96 -2004) with : A B C D 1 Name Lost time Age Gender 2 elmo 2 3 elmo 0 4 Bert 1 5 Bert 36 6 ernie 0 7 big bird 0 8 oskar 0 I want to sum the total of lost days per person from the yearly worksheets and enter it under the respective year int he lost days worksheet. For example, I want know who may days did Bert lose in 96-97. I I thought I could use sumif, but I'm the problem is I don't know how to tell it to sum the colum B of rows that where it found the name Bert. I know $ make it always do colum B, but what symbol do I use to say "from the rows the correspond with the name (criteria)"? For Bert the formula would be: =SUMIF('96-97'!A2:A36,'Lost days'!A2,'96-97 SIF'!$B4:$B5) That would not work for anyone else as the row for their data are different =SUMIF('96-97'!A2:A36,'Lost days'!A2,'96-97 SIF'!$B?:$B?). Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF function help | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions |