sumif columns and rows

P

Paul Clough

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

Frank Kabel

Hi Paul
not tested but try something like
=SUMPRODUCT((A2:A25="donation")*(B1:AX1="unrestricted")*(B2:AX25))
 
P

Paul Clough

Frank,

Thanks - worked a treat.

Paul

Frank Kabel said:
Hi Paul
not tested but try something like
=SUMPRODUCT((A2:A25="donation")*(B1:AX1="unrestricted")*(B2:AX25))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SUM + INDEX in array formula 5
use month in cell date to sum all relevant cells 2
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
SumIf AND 6
sumifs/sumproduct 8
Using Sumifs 3
Sorting with sumif function 2
Problem with SUMIF Formula 3

Top