claire_pike
New Member
- Joined
- Aug 10, 2006
- Messages
- 40
Hi,
I am trying to perform a SUMIF function and would like to add multiple criteria but having some trouble.
So what I want to do is
SUMIF(Master!E:E,A2,Master!N:N)
but need to add the criteria
VLOOKUP(A2,Master!E:H,4,FALSE)="Exchange RFS"
Any ideas?
Cheers,
Claire
I am trying to perform a SUMIF function and would like to add multiple criteria but having some trouble.
So what I want to do is
SUMIF(Master!E:E,A2,Master!N:N)
but need to add the criteria
VLOOKUP(A2,Master!E:H,4,FALSE)="Exchange RFS"
Any ideas?
Cheers,
Claire