Hi,

Am Fri, 11 Sep 2015 10:58:26 +0200 schrieb Claus Busch:

For example: If you want to sum COST for each "B" in Category:
=SUMIFS(INDEX(A:D,,MATCH("COST",A1:D1,0)),A:A,"B")

or use a Pivot table.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional