| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate totals
Mike, use something like this,
=SUMIF(A1:A10,"bananas",B1:B10) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mike Mike" wrote in message ... This is what I got: bananas 5 9 3 1 bananas 1 2 7 3 bananas 8 7 4 2 oranges 1 5 1 3 oranges 2 4 8 2 pears 9 5 2 3 pears 7 5 2 3 etc...... I need one row with the totals for each "fruit" bananas 14 18 14 6 oranges 3 9 9 5 pears 16 10 4 6 etc... Anyone know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filters and totals | Excel Discussion (Misc queries) | |||
| Filtering and Totals | Excel Discussion (Misc queries) | |||
| How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
| I need to input daily cost codes would exceli calculate my totals | Excel Worksheet Functions | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Threaded Mode
