Im having a hard time get the formula correct if its even possible.



I have a Win Loss Spread sheet and im trying to summerize it on one sheet by statistics through out a 17 week period.

each sheet is a week..week 1,2,3,4..so on.
I can summerize one week at a time but not all the sheets progressively.

If i try to add all the weekly tabs, with this formula, it gives me an error..
=SUMPRODUCT(--('Week 1 :[Week 17]Week 17'!C$9:$C$18="Casey"),--('Week 1 :[Week 17]Week 17'!I$9:$I$18="L"))

If I place this in for only one week tab it works fine.
=SUMPRODUCT(--('Week 1 '!$C$9:$C$18="Casey"),--('Week 1 '!$H$9:$H$18="L"))

anyone have any ideas or a simpler way?

Thanks!!!

Hi
I don't think 3 D references work with SUMPRODUCT

Maybe create a formula in the same cell in each sheet and add the results with the SUM function which allows for 3 D

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pecoflyer,

Small issue. Each person will have to have totals on each sheet with 5 potential players and maybe 4-5 stats a piece...that would take up alot of space on each sheet..unless I hide the cells i guess.

Can i give you my example? you may see something easier by seeing it.
Thanks ahead of time.

Well, now I have no idea what I did...this is now more confusing to place all the weeks in one sheet..not only that, my formulas are all wrong and I cant figure them out....

What are the chances someone can look at this and help me out...maybe if i just tell someone where i want the information to show up, the formulas will be easy to copy and paste.

Thanks

Could you possibly post a small sample sheet describing " before" and "after" ?
( to post a sheet click edit on a post - Go Advanced - Click the paperclip)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Cross post

http://www.excelforum.com/excel-gene...97#post2681897

and

http://www.mrexcel.com/forum/showthread.php?t=605405


Read this about cross posting

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Well, now i know all the forums are linked..didnt know that..figured as I was working on the spread sheet and i hit a road block and didnt get an answer on the other 2 for 2 days, so i started this one.....so sorry to triple post.

let me get the two copies up so you can see what i started and what i attemped to change.

I would love to keep the APA file..and dispose of the APA2...once i know how to pull the data according to name, i can start tweeking the look again.

Thanks again, and also sorry.

Attached Files

	APA.xlsx (60.0 KB, 11 views)
	APA2.xlsx (46.2 KB, 9 views)

here is the after results i was planning on getting progressivly throughout the weeks....

Is it possible??? like i stated I was able to pull from one tab but not progressively..
and I couldnt tell the program to only count in the data is playing "our team"=Casey,Kaleena,Rob,Brian,Billy,Laurel.

I

Attached Files

APA after.xlsx (59.4 KB, 12 views)