View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Help with another formula

"Needs help" wrote:
.. need to add up the totals of the amounts in the cells
only that only contained the word "internet" ..Thanks!


Assuming B1:B20 contain the amounts to be summed,
with A1:A20 housing text such as "internet"

If you're still talking multi-conditions, then use eg:
=SUMPRODUCT((A1:A20="Internet")*(B1:B20=100),B1:B 20)
which will sum only the amounts =100 in col B
where col A contains: internet

If it's only for a single condition, use SUMIF, eg:
=SUMIF(A1:A20,"internet",B1:B20)

Think SUMIF will suffice for you here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---