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.
|