| View previous topic :: View next topic |
| Author |
Message |
sudarshan_t
Newbie
Joined: 18 Jun 2012
Posts: 2
|
 Posted: Mon Jun 18, 2012 10:08 pm Post subject: Whats wrong with this formula? |
 |
|
| =SUMPRODUCT(SUBTOTAL(3;OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()));ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN())))-MIN(ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN()))));;1))*(E$2:E2(ADDRESS(ROW()-2;COLUMN()))=$'Staffing Foundation'.$A$2))*$'Staffing Foundation'.$B$2+SUMPRODUCT(SUBTOTAL(3;OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()));ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN())))-MIN(ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN()))));;1))*(E$2:E2(ADDRESS(ROW()-2;COLUMN()))=$'Staffing Foundation'.$A$3))*$'Staffing Foundation'.$B$3+SUMPRODUCT(SUBTOTAL(3;OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()));ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN())))-MIN(ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN()))));;1))*(E$2:E2(ADDRESS(ROW()-2;COLUMN()))=$'Staffing Foundation'.$A$4))*$'Staffing Foundation'.$B$4+SUMPRODUCT(SUBTOTAL(3;OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()));ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN())))-MIN(ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN()))));;1))*(E$2:E2(ADDRESS(ROW()-2;COLUMN()))=$'Staffing Foundation'.$A$5))*$'Staffing Foundation'.$B$5+SUMPRODUCT(SUBTOTAL(3;OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()));ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN())))-MIN(ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN()))));;1))*(E$2:E2(ADDRESS(ROW()-2;COLUMN()))=$'Staffing Foundation'.$A$6))*$'Staffing Foundation'.$B$6+SUMPRODUCT(SUBTOTAL(3;OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()));ROW(E$2:E2(ADDRESS(ROW()-2;COLUMN())) |
|
| Back to top |
|
 |
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
| Posted: Mon Jun 18, 2012 11:16 pm Post subject: |
|
|
Hallo
| Quote: | | Whats wrong with this formula? |
its a big mess without any sense!
Karo |
|
| Back to top |
|
|
sudarshan_t
Newbie
Joined: 18 Jun 2012
Posts: 2
|
| Posted: Tue Jun 19, 2012 12:48 am Post subject: |
|
|
| This formula works in excel |
|
| Back to top |
|
|
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
| Posted: Tue Jun 19, 2012 1:24 am Post subject: |
|
|
| Quote: | | This formula works in excel |
No !
...because thats never valid Syntax:
| Code: | | ..OFFSET(E$2:E2(ADDRESS(ROW()-2;COLUMN()))... |
|
|
| Back to top |
|
|
|
