Nested "sumif" functions

[Colin]

I need to produce a report that summarises by expense, by
period for each of eleven locations the amount spent, and
am trying to nest "sumif" functions - is this possible, or
is there some other method?

 

[JE McGimpsey]

This is a perfect application for a pivot table.

See http://peltiertech.com/Excel/Pivots/pivotstart.htm
if you're not familiar with them.

 

[Bernie Deitrick]

Colin,

Try using a Pivot Table. Look in help, or visit any of these:

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

HTH,
Bernie
MS Excel MVP