-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vague
-
F
How can I make this work - sorry for the vague title!
=SUMPRODUCT(SUBTOTAL(3,OFFSET(Cohort!$L$13:$L$2002,ROW(Cohort!$L$13:$L$2002)-MIN(ROW(Cohort!$L$13:$L$2002)),,1))*(Cohort!$L$13:$L$2002>5<21)) It works for =SUMPRODUCT(SUBTOTAL(3,OFFSET(Cohort!$L$13:$L$2002,ROW(Cohort!$L$13:$L$2002)-MIN(ROW(Cohort!$L$13:$L$2002)),,1))*(Cohort!$L$13:$L$2002<=5))...- Fazila
- Thread
- make title vague work
- Replies: 3
- Forum: Excel Questions
-
B
Cumulative Growth
Hi, I have the following % and I would like to know how I use these % to work out a cumulative growth please? I haven't done this before so apolgies if this seems vague as im not too sure what to do. 110% 28% 67% 74%- brandon16
- Thread
- 110% apolgies cumulative growth vague
- Replies: 1
- Forum: Excel Questions
-
M
Sequencing Formula
Hi All, Would someone please be able to advise the quick way to auto fill a column based on the below pattern? =Sheet1!H3*Sheet2!B3 =Sheet1!I3*Sheet2!B4 =Sheet1!J3*Sheet2!B5 =Sheet1!K3*Sheet2!B6 New to this so apologise if vague or simple! Thanks.- mattyb1811
- Thread
- apologise based pattern simple vague
- Replies: 5
- Forum: Excel Questions
-
B
sumif query
hey should this sumif work over a number of columns? I'm trying to sum the total of numbers in columns W through to AB. =sumif(B12:B200,C4,W12:AB200) sorry if vague!- BrutalLogiC
- Thread
- columns numbers sumif total vague
- Replies: 4
- Forum: Excel Questions
