TinaP
Well-known Member
- Joined
- Jan 26, 2005
- Messages
- 528
I'm trying to count the number of loans we have according to status and processor. The status (1,2,3,4) is in column S and the processors initials are in column J. For instance I would like to know how many loans we have with status 3 being processed by ABC.
I tried using sumproduct, but I'm not very experienced with it, so I didn't do very well. I'd rather not use array formulas since the person I'm doing this for has been know to modify formulas and I know he won't remember CTRL+ALT+ENTER.
I tried using sumproduct, but I'm not very experienced with it, so I didn't do very well. I'd rather not use array formulas since the person I'm doing this for has been know to modify formulas and I know he won't remember CTRL+ALT+ENTER.