Hi All
I'm hoping for some help my little project. I trying to calculate info gathered from each name on other sheets and finalize them on a summary sheet with an overall average for each name.
I upload a sample sheet to help clarify what I'm looking for.
Thanks in advance
Do you want a count or a sum?
Are the real number values supposed to be all 1s? The average is easy, it's 1!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony
The number values are only 1"s (more like a Yes or No). Depending on how many compliant of non compliant the letter has, in say over a months would give the average total of the letter. I hope I explained myself. Thanks for looking into it for me
Regards
An example would be if john (letter) did various jobs each month and was rated on each job if it was done proper or not proper. Then it would tallied on the summary page. The same would be if Mary or Joe was rate the same way. This way I could quickly figure out how was doing the best.
Regards
Try this...
Data Range
List the sheet names in a horizontal array. I've used cells A1:B1.
I'm not sure what you expect for an average.
Enter this formula in B5:
=SUMPRODUCT(SUMIF(INDIRECT("'"&A$1:B$1&"'!A5:A24"),A5,INDIRECT("'"&A$1:B$1&"'!B5:B24")))
Enter this formula in C5:
=SUMPRODUCT(SUMIF(INDIRECT("'"&A$1:B$1&"'!A5:A24"),A5,INDIRECT("'"&A$1:B$1&"'!C5:C24")))
Select B5:C5 and copy down as needed.
Thanks I'll give it a go. Appreciate it and I'll let you know
Thanks You Tony V. I had a couple of small issues but it was at my end
I appreciate the help on this. I'm going to practice this on other home projects
Regards
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks