test

Need help with Excel 2010

MattyB

Moderator
Joined
Mar 19, 2012
Messages
2,918
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. :(
 

jacobberke

Member
Joined
Nov 4, 2012
Messages
205
Hmm I don't use excel that much, but have you tried searching YouTube. Sorry I couldn't help out.
 

MattyB

Moderator
Joined
Mar 19, 2012
Messages
2,918
I worked around it. All good now. Couldn't find the answers I was looking for on Google. I didn't really know the question I was asking.
 
Top