JohnDouglas
Board Regular
- Joined
- Jan 5, 2005
- Messages
- 239
I've tried and tried . but don't seem to be able to get the right formula or even workout which function i should thorougly investigate.
please please please tell me how to sort this out.
I'm trying to produce a report that sums the total once three variables are met.
so, if i have three sites in:
column A: London, Paris, Tokyo.
column B: three different types of fruit (for simplicities sake ) apple, pear, banana.
column C: will say whether it has been "eaten" or "not eaten".
what i want to sum is each of the possible outcomes..
so for the three cities i'd like to see how many apples have been eaten and how many not eaten and the same for the pears and bananas.
please can anyone give me teh formula that will achieve this??
thanks very much in advance for your help
yours
john
please please please tell me how to sort this out.
I'm trying to produce a report that sums the total once three variables are met.
so, if i have three sites in:
column A: London, Paris, Tokyo.
column B: three different types of fruit (for simplicities sake ) apple, pear, banana.
column C: will say whether it has been "eaten" or "not eaten".
what i want to sum is each of the possible outcomes..
so for the three cities i'd like to see how many apples have been eaten and how many not eaten and the same for the pears and bananas.
please can anyone give me teh formula that will achieve this??
thanks very much in advance for your help
yours
john