dont forget the ctrl-shift-enter on E6 - while in edit mode .

"driller" wrote:

i am also trying and confused
but try this...with your data on rows 1:5
assuming that column D contain real sensible dates (not a text) formatted in
"mmm-yy"
somewhere at the bottom of your table, say on row 6, summing criteria
A6: sue
B6 : 4
C6: Y
D6 : 1/1/2007 : (this represent the whole month of Jan-07)

formula to sum only

E6
=SUM((A1:A5=A6)*(B1:B5=B6)*(C1:C5=C6)*(MONTH(D1:D 5)=MONTH(D6))*(YEAR(D1:D5)=YEAR(D6))*E1:E5)


"Mark Allen" wrote:

I tried all sorts but never got the right answer !!!


Can you help please ????

"driller" wrote:

You are frustrated. Why? What formula did you try to learn this? you can post
it here, don't be shy to learn.

"Mark Allen" wrote:

I have a range a cells as below:

A B C D E
Sue 1 N Jan-07 20,000
Jo 3 N Feb-07 10,000
Peter 4 Y Jan-07 30,000
Sue 5 Y Jan-07 20,000
Sue 7 Y Jan-07 10,000

I want to calculate total value of E when A=Sue, B=4, C=Y and
D=Jan-07...therefore the answer being 30,000

PLEASE HELP !!!!!! Its so frustrating when you are trying to learn......