xl_psychic
Active Member
- Joined
- Jan 4, 2004
- Messages
- 359
Gurus:
I am trying to build a sumproduct function which would help me count the total number of active people belonging to a specific group of code.
The only twist is this group code would have variants, for eg: TRGB21, TRGB22, TRGB23 etc.
I tried entering the following formula to count the number of active people in all training batches,
=SUMPRODUCT(('Att Details'!D:D=C6&"*")*('Att Details'!AK:AK="Active"))
where C6 houses the value TRGB
I get a #NUM! error while trying this formula.
=COUNTIF('Att Details'!D:D,C6&"*") gives me the figure but does not take the active/inactive status into consideration.
Help appreciated.
I am trying to build a sumproduct function which would help me count the total number of active people belonging to a specific group of code.
The only twist is this group code would have variants, for eg: TRGB21, TRGB22, TRGB23 etc.
I tried entering the following formula to count the number of active people in all training batches,
=SUMPRODUCT(('Att Details'!D:D=C6&"*")*('Att Details'!AK:AK="Active"))
where C6 houses the value TRGB
I get a #NUM! error while trying this formula.
=COUNTIF('Att Details'!D:D,C6&"*") gives me the figure but does not take the active/inactive status into consideration.
Help appreciated.