Multiple Sum IF ... is it possible ??
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......
|