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......