sumproduct
Try this:
=COUNTA(G12:P12)*($G$2)-SUMPRODUCT((LEFT(G12:P12)="F")*($G$2))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Lacey" wrote in message
...
Hi - I'm having awful problems using a wildcard in a sumproduct formulae -
if
anyone could help me it would be hugely appreciated the formulae is as
follows:
COUNTA(G12:P12)*($G$2)-SUMPRODUCT((G12:P12="F*")*($G$2))
Thanks heaps for your help,
Lacey
|