How to calculate sum per category?

P

praiser

Hey there

Does anybody know how I can calculate the sum of a range of numbers
but only if they are in a specific category?

Example table in Excel: look attachment

Thank you very much
Florian Meye

+-------------------------------------------------------------------
|Filename: excel.gif
|Download: http://www.excelforum.com/attachment.php?postid=4437
+-------------------------------------------------------------------
 
E

EdMac

Use SUMIF function

=SUMIF(Source range,criteria,sumrange)

e.g. SUMIF(A1:A6,1,B1:B6)

Ed
 
Top