Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing text of a cell next to the greatest value in column | Excel Worksheet Functions | |||
SumIF referencing to a CELL, rather than text.... | Excel Worksheet Functions | |||
chart Label text referencing worksheet cell value | Charts and Charting in Excel | |||
Referencing cell text in a lookup | Excel Discussion (Misc queries) | |||
Referencing text in a cell in a formula | Excel Discussion (Misc queries) |