| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if column is equal to 2 options
Column A contains 3 types of data ie apples, oranges or lemons. Column B
contains the number of each item purchased and col C contains the date of purchase. I need a formula which will count the total number of apples and oranges purchased in May. (Answer should be 20) Grateful for any help. Col A Col B Col C apples 5 4/5/08 apples 6 6/5/08 lemons 4 7/5/08 apples 1 1/6/08 oranges 9 3/5/08 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight column A if column A does not equal to B | New Users to Excel | |||
| Need to sum a column if two cells in row are equal | Excel Worksheet Functions | |||
| first number in a column not equal to zero | New Users to Excel | |||
| How do I get text to equal a number so I can sum a column? | Excel Discussion (Misc queries) | |||
| getting excel to print text equal to a column | Excel Discussion (Misc queries) | |||
Threaded Mode
