sum in excel

  • Thread starter Thread starter fernango
  • Start date Start date
F

fernango

I am trying to do a summary of hundreds of items which names start
with "ENG" (there are more categories), what I would like to have is a
summary of clumn E for items in column A that start with "ENG".

Thanks
 
Look in the help index for SUMIF and incorporate a wildcard *eng
or use
=sumproduct((left(a2:a22,3)="eng")*e2:e22)
 
Assuming your criteria (e.g. ENG) is in cell G1, put the following
formula in cell H1

=SUMIF($A$2:$A$500,G1&"*",$E$2:$E$500)

Put additional criteria below G1.... and copy down the formula from
H1.

Francis Hayes (The Excel Addict)

Get my FREE 'Spreadsheet Tips From An Excel Addict' Newsletter at
http://www.TheExcelAddict.com
 
Back
Top