sumproduct
 

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

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

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

sumproduct
 

Brilliant - thanks heaps guys working beautifully!

"RagDyeR" wrote:

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

sumproduct
 

We appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lacey" wrote in message
...
Brilliant - thanks heaps guys working beautifully!

"RagDyeR" wrote:

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