Need help with Excel 2010


Resource Administrator / Forum Moderator
Mar 19, 2012
Adelaide, Australia
Hopefully there are a few Excel experts out there who can help me. This could be confusing but I'll explain the best I can. I have a workbook with 32 worksheets. One for each day of the month plus one at the end for collating info from the other sheets. Each daily sheet has a number of names (often a number of times per sheet) with a dollar amount next to each entry. I know how to sum specific data on each sheet (ie each time PERSON1 is listed it will add up only that data) using the SUMIF fuction eg. SUMIF(A1:A100,"=PERSON1",B1:B100) but I want the last sheet on the workbook to add up all the daily entries for PERSON1 and every other person over the entire workbook separately.

I feel like I am missing something simple here but I can't figure it out.

AGGGHHHHHHH!!!!!!!! I'm getting a headache!

- - - - - Updated; Double Post Auto Merged - - - - -

So no Excel geniuses out there??? Disappointing. :(