sumproduct
Try it with:
LEFT(G12:P12,1)="F"
Hope this helps.
Pete
On Jul 31, 4:18*pm, Lacey wrote:
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
|