wrt1mea
asked on
I need an excel formula
I am trying to reference a range of cells to look for a specific persons name. For example, if I had Agents 1 though 10. Instead of doing 10 seperate formulas. Look at the very last part of the formula .
=SUMPRODUCT(((SRDATA!$H$2: $H$10000>= $A114)*(SR DATA!$H$2: $H$10000<= $B114)+(SR DATA!$I$2: $I$10000>= $A114)*(SR DATA!$I$2: $I$10000<= $B114)+(SR DATA!$M$2: $M$10000>= $A114)*(SR DATA!$M$2: $M$10000<= $B114)>0)* (SRDATA!$K $2:$K$1000 0="N")*(SR DATA!$C$2: $C$10000=A 21:A49)).
It isnt working and I need to be able to do something like that or I will have a 28 entry sumproduct formula.
=SUMPRODUCT(((SRDATA!$H$2:
It isnt working and I need to be able to do something like that or I will have a 28 entry sumproduct formula.
Could you post a sample sheet please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ASKER
Fantastic! Helped speed up the computations as well!