sumif columns and rows
 

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.

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.

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.