View Single Post
  #1   Report Post  
Paul Clough
 
Posts: n/a
Default 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.