sumifs using rows and colums

[p4nny]

Hi,

I would to use a sumifs formula to sum both rows and columns..

I've tried the standard sumifs and this doesn't work.

Maybe sumifs isn't the best method

Appreciate the support

 

[proficient]

What is the summing range...? criteria column...? Need the formula you are currently using...

 

[gaz_chops]

A sample of your data and what you are trying to achieve would be helpful.

 

[p4nny]

sure,

=SUMIFS(E$9:E$30,$C$9:$C$30,$C91,$E$5:$I$5,B91) This returns #value!

C9:C30 is the COLUMN but as another criteria I would like to add ROW E5:I5.

Thanks

 

[gaz_chops]

sure,

=SUMIFS(E$9:E$30,$C$9:$C$30,$C91,$E$5:$I$5,B91) This returns #value!

C9:C30 is the COLUMN but as another criteria I would like to add ROW E5:I5.

Thanks

And a sample of your data! And what is the criteria for row5?