Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct(?) | Excel Discussion (Misc queries) | |||
Sumproduct with OR | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |