Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif and autofill
I want to use autofill to increase =SUMIF(WEEK1!$C$7:$L$7,"100",WEEK1!$C$298:$L$298) to =SUMIF(WEEK2!$C$7:$L$7,"100",WEEK2!$C$298:$L$298) =SUMIF(WEEK3!$C$7:$L$7,"100",WEEK3!$C$298:$L$298) ect ect.... Thanx:) -- Grimzby ------------------------------------------------------------------------ Grimzby's Profile: http://www.excelforum.com/member.php...o&userid=23905 View this thread: http://www.excelforum.com/showthread...hreadid=375420 |
#2
|
|||
|
|||
Hi!
=SUMIF(WEEK1!$C$7:$L$7,"100",WEEK1!$C$298:$L$298) Is "100" a text value or a numeric value? As you have it enclosed in quotes Excel will treat it as TEXT. Try this: =SUMIF(INDIRECT("Week"&ROW(1:1)&"!C7:L7"),100,INDI RECT("Week"&ROW(1:1)&"!C298:L298")) Copy down as needed. Biff "Grimzby" wrote in message ... I want to use autofill to increase =SUMIF(WEEK1!$C$7:$L$7,"100",WEEK1!$C$298:$L$298) to =SUMIF(WEEK2!$C$7:$L$7,"100",WEEK2!$C$298:$L$298) =SUMIF(WEEK3!$C$7:$L$7,"100",WEEK3!$C$298:$L$298) ect ect.... Thanx:) -- Grimzby ------------------------------------------------------------------------ Grimzby's Profile: http://www.excelforum.com/member.php...o&userid=23905 View this thread: http://www.excelforum.com/showthread...hreadid=375420 |
#3
|
|||
|
|||
Assuming that you want to enter your formula in B2 and copy down, try the following formula... =SUMIF(INDIRECT("WEEK"&ROWS($B$2:B2)&"!C7:L7"),"10 0", INDIRECT("WEEK"&ROWS($B$2:B2)&"!C298:L298")) Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=375420 |
#4
|
|||
|
|||
Thanx....both work great:).....spent hours reading and couldnt find an answer. The 100 is numeric value....can it be made to autofill in increments of 1 also.... Thanx again. -- Grimzby ------------------------------------------------------------------------ Grimzby's Profile: http://www.excelforum.com/member.php...o&userid=23905 View this thread: http://www.excelforum.com/showthread...hreadid=375420 |
#5
|
|||
|
|||
Hi!
Try: =SUMIF(INDIRECT("Week"&ROW(1:1)&"!C7:L7"),100+ROWS ($1:1)-1,INDIRECT("Week"&ROW(1:1)&"!C298:L298")) Biff "Grimzby" wrote in message ... Thanx....both work great:).....spent hours reading and couldnt find an answer. The 100 is numeric value....can it be made to autofill in increments of 1 also.... Thanx again. -- Grimzby ------------------------------------------------------------------------ Grimzby's Profile: http://www.excelforum.com/member.php...o&userid=23905 View this thread: http://www.excelforum.com/showthread...hreadid=375420 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|