View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tricia, not Patricia Tricia, not Patricia is offline
external usenet poster
 
Posts: 1
Default Referencing text from another cell for criteria in functions

I know how to enter text as a criteria, but am looking for a way around
manually editing the text when doing multiple functions.

Example:
I give out different kinds of fruit to my students each day and enter the
amounts of each type into a spreadsheet daily. I want to add up how many of
each fruit were distributed.

Column A holds fruit names, column B holds quantities, and column D holds a
list of all the types of fruit. I would like to add totals for each type in
column E.

I could enter =SUMIF(A:A,"=fruitname",B:B) for each fruit in my list, but
I'd have to delete 'fruitname' and enter in each new fruit. How would I write
a function for "If any cells in column A equals the text in cell D2, add the
number of the corresponding cells in column B and enter the sum in cell E2."