Thread
:
Referencing text from another cell for criteria in functions
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
Posts: 2,389
Referencing text from another cell for criteria in functions
You do it this way:
=sumif(A:A,"="&D2,B:B)
Or, more simply:
=sumif(A:A,D2,B:B)
Even better would be to create a pivot table. Give it a try. You'll be
amazed how easy and powerful it is.
Regards,
Fred
"Tricia, not Patricia" <Tricia, not
wrote in message ...
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."
Reply With Quote
Fred Smith[_4_]
View Public Profile
Find all posts by Fred Smith[_4_]