need help adding across and down

[Mighty Magpie]

Hello,

On a sheet named data I have the following

Mon Tue Wed Thu
A3 = BILL 1 1 1
A4 = FRED 1 1
A5 =TOM 1
A6 = BILL 1
A7 = TOM 1 1

I want to have a grid on a different sheet (named results) which looks at
the above data and then returns the totals for Bill on each day, the totals
for Fred each day etc. I need to see how many each did on each day

So not only does it need to 'add the totals across the sheet, it also needs
to add them up going down the sheet

Can someone please advise me as to how to achieve it?

Many thanks


Using Win XP Pro and Excel 2002

 

[Bob Phillips]

Will you have a similar format on the other sheet, without the duplicate
names? assuming so,
on sheet2, B3: =SUMIF(Sheet1!$A$3:$A$100,$A3,Sheet1!B$3:B$100)
copy across and down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Mighty Magpie]

Thanks for the reply

Maybe I'm doing something wrong because it only retuns a load of zeros (one
in each cell)

 

[Mighty Magpie]

Yep,

I was doing something wrong and now it works fine for me

many thanks