Im sure the answer is out there!!!!

[JoshuaMars]

Hi there Excel users,

Im trying to complete this formula.

Im sure its easy for someone out there with more expertise then me.

=SUMIF('Sports Daily'!B390:'Sports Daily'!B466,"=*ATP*",'Sports Daily'!C390:'Sports Daily'!C466)

What Im trying to work out is the ATP area of it. ATP is in a cell that comes from a workshet name.
=IF(COUNTA(SHEETS)>=ROW($A1),INDEX(SHEETS, ROW($A1)), "")

So basicly, the ATP is a workshet name, and if i change the name of the worksheet, the cell changes and so does the SUMIF formula.

HELP me please anyone. Im lost.

 

[Norie]

Perhaps I'm missing something but couldn't you just replace ATP with a cell reference in this formula.

=SUMIF('Sports Daily'!B390:B466,"=*ATP*",'Sports Daily'!C390:C466)

eg

=SUMIF('Sports Daily'!B390:B466,"*" & A1 & "*",'Sports Daily'!C390:C466)

where A1 contains ATP or whatever.

Hatman

COUNTIF does support wildcards.

 

[Peter_SSs]

Perhaps I'm missing something but couldn't you just replace ATP with a cell reference in this formula.

Yes Norie, I think that is what is required and that is why I have been asking what cell the formula returning "ATP" is in. My suggestion is this:

Joshua
Your response indicates that cell C5 of sheet 'Weekly' contains the formula
=IF(COUNTA(SHEETS)>=ROW($A1),INDEX(SHEETS, ROW($A1)), "")
and this formula returns the result 'ATP'. That being the case, in C5 of sheet 'Centerbet_06-07' try this formula:
=SUMIF('Sports Daily'!B390:B466,Weekly!C5,'Sports Daily'!C390:C466)