Sumproduct?
You've added the two booleans (with the --), rather than allowing SUMPRODUCT
to multiply them.
I guess that instead of
=SUMPRODUCT(--(Start_Rep:Finish_Rep=B4)--(Start:Finish="*Utility - *"))
you may have intended
=SUMPRODUCT(--(Start_Rep:Finish_Rep=B4),--(Start:Finish="*Utility - *")) or
=SUMPRODUCT((Start_Rep:Finish_Rep=B4)*(Start:Finis h="*Utility - *"))
--
David Biddulph
"Looping through" wrote in
message ...
I am tring to count the number of time a specific text appears in a range.
The following formula counts the total number of entries in my range but
is
not seperating the specific text I want. Can anyone help with this?
=SUMPRODUCT(--(Start_Rep:Finish_Rep=B4)--(Start:Finish="*Utility - *"))
Thanks
Peter
|