SumProduct

[RadicalNotion]

I keep getting #value error when using sumproduct and can't seem to find a way around it.
I would like to do two things,

1) Sum the rows labeled Mike and columns labeled A. (Basically cells C4, E4, C6, E6)

2) Sum the rows labeled Larry and Dave and columns labeled D and E. (Basically cells F7, F8, G7, G8)

I could probably get around the #value error by rearranging the label rows but would really prefer to keep them as is and work around that error with a proper formula. Thanks!

[ConneXionLost]

Hi,

For 1) Use:

Please Login or Register  to view this content.

and for 2) Use:

Please Login or Register  to view this content.

Cheers,

[RadicalNotion]

I would prefer to keep the header text row in the third array because occasionally I have to work with data where there is a row of text in between rows of numbers that I need to sum.