forumla that counts total per month

[JohnDouglas]

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.

Through the help on this site i now can produce a report that sums the total once three variables are met.

So far i have:
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".

I have the formula which sums 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.

so, now i'd like to add another column D for date. so i can sum all the data for eaten, not eaten in a particular month like feb and march. any ideas on how to achieve this?

the original formula given by the very helpful phantom (thanks mate) was: =SUMPRODUCT(($A$1:$A$17="London")*($B$1:$B$17="apple")*($C$1:$C$17="eaten"))

the original answer was here:
http://www.mrexcel.com/board2/viewtopic.php?t=127441&highlight=

please can anyone give me teh formula that will achieve this??

as always, thanks very much in advance for your help

yours

john

 

[Oaktree]

Try:

=SUMPRODUCT(($A$1:$A$17="London")*($B$1:$B$17="apple")*($C$1:$C$17="eaten")*(month($C$1:$C$17)=2))

for Feb.

 

[JohnDouglas]

Fantastic Oaktree....I love you !

formula works perfectly.

thanks for your help

yours

john