Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have an array that has about 100 columns and 25 rows.
I am trying to sum all the cells within the array that satisfy conditions within the header rows and columns (e.g. all the cells with columns titled "unrestricted" AND rows titled "donation"). I am sure that sumif or sumproduct must hold the solution but this is proving elusive. |
#2
![]() |
|||
|
|||
![]()
Hi Paul
not tested but try something like =SUMPRODUCT((A2:A25="donation")*(B1:AX1="unrestric ted")*(B2:AX25)) "Paul Clough" wrote: I have an array that has about 100 columns and 25 rows. I am trying to sum all the cells within the array that satisfy conditions within the header rows and columns (e.g. all the cells with columns titled "unrestricted" AND rows titled "donation"). I am sure that sumif or sumproduct must hold the solution but this is proving elusive. |
#3
![]() |
|||
|
|||
![]()
Frank,
Thanks - worked a treat. Paul "Frank Kabel" wrote: Hi Paul not tested but try something like =SUMPRODUCT((A2:A25="donation")*(B1:AX1="unrestric ted")*(B2:AX25)) "Paul Clough" wrote: I have an array that has about 100 columns and 25 rows. I am trying to sum all the cells within the array that satisfy conditions within the header rows and columns (e.g. all the cells with columns titled "unrestricted" AND rows titled "donation"). I am sure that sumif or sumproduct must hold the solution but this is proving elusive. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Rows and columns | New Users to Excel |