M
Mark Allen
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......
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......