software

The following formula gives me a zero result :
=SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))

I want to count all occurences of valuesgt;$0.00 in Column F only if column
B=Joe in a filtered list.

Thank you

Assuming your values in Col F are real numbers, take the quotes off the 0

=SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;0))

or

=SUMPRODUCT(--(B2:B18=quot;joequot;),--(F2:F18gt;0))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
quot;vacationquot; gt; wrote in message
...
gt; The following formula gives me a zero result :
gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt;
gt; I want to count all occurences of valuesgt;$0.00 in Column F only if column
gt; B=Joe in a filtered list.
gt;
gt; Thank you
quot;vacationquot; gt; wrote in message
...
gt; The following formula gives me a zero result :
gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt;
gt; I want to count all occurences of valuesgt;$0.00 in Column F only if column
gt; B=Joe in a filtered list.

It should be:

=SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;0))

Bruno
Remove the quotes for your second condition...

=SUMPRODUCT((B2:B18=quot;Joequot;)*(F2:F18gt;0))

For a filtered list, try the following...

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(B2:B18,ROW(B2:B18)-ROW(B2),0,1))),--(B2:
B18=quot;Joequot;),--(F2:F18gt;0))

Hope this helps!

In article gt;,
quot;vacationquot; gt; wrote:

gt; The following formula gives me a zero result :
gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt;
gt; I want to count all occurences of valuesgt;$0.00 in Column F only if column
gt; B=Joe in a filtered list.
gt;
gt; Thank you

Thank you so much! I have been working on this for months.

quot;Ken Wrightquot; wrote:

gt; Assuming your values in Col F are real numbers, take the quotes off the 0
gt;
gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;0))
gt;
gt; or
gt;
gt; =SUMPRODUCT(--(B2:B18=quot;joequot;),--(F2:F18gt;0))
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------Â*------------------------------Â*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------Â*------------------------------Â*----------------
gt;
gt;
gt;
gt; quot;vacationquot; gt; wrote in message
gt; ...
gt; gt; The following formula gives me a zero result :
gt; gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt; gt;
gt; gt; I want to count all occurences of valuesgt;$0.00 in Column F only if column
gt; gt; B=Joe in a filtered list.
gt; gt;
gt; gt; Thank you
gt;
gt;
gt;

Thank you very much! It works!

quot;Bruno Campaniniquot; wrote:

gt; quot;vacationquot; gt; wrote in message
gt; ...
gt; gt; The following formula gives me a zero result :
gt; gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt; gt;
gt; gt; I want to count all occurences of valuesgt;$0.00 in Column F only if column
gt; gt; B=Joe in a filtered list.
gt;
gt; It should be:
gt;
gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;0))
gt;
gt; Bruno
gt;
gt;
gt;

You're very welcome :-)

Regards
Ken...........................

quot;vacationquot; gt; wrote in message
...
gt; Thank you so much! I have been working on this for months.
gt;
gt; quot;Ken Wrightquot; wrote:
gt;
gt;gt; Assuming your values in Col F are real numbers, take the quotes off the 0
gt;gt;
gt;gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;0))
gt;gt;
gt;gt; or
gt;gt;
gt;gt; =SUMPRODUCT(--(B2:B18=quot;joequot;),--(F2:F18gt;0))
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt; Ken....................... Microsoft MVP - Excel
gt;gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;gt;
gt;gt; ------------------------------*------------------------------*----------------
gt;gt; It's easier to beg forgiveness than ask permission :-)
gt;gt; ------------------------------*------------------------------*----------------
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;vacationquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The following formula gives me a zero result :
gt;gt; gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt;gt; gt;
gt;gt; gt; I want to count all occurences of valuesgt;$0.00 in Column F only if
gt;gt; gt; column
gt;gt; gt; B=Joe in a filtered list.
gt;gt; gt;
gt;gt; gt; Thank you
gt;gt;
gt;gt;
gt;gt;
Thank you, that was fast.

quot;Domenicquot; wrote:

gt; Remove the quotes for your second condition...
gt;
gt; =SUMPRODUCT((B2:B18=quot;Joequot;)*(F2:F18gt;0))
gt;
gt; For a filtered list, try the following...
gt;
gt; =SUMPRODUCT(--(SUBTOTAL(3,OFFSET(B2:B18,ROW(B2:B18)-ROW(B2),0,1))),--(B2:
gt; B18=quot;Joequot;),--(F2:F18gt;0))
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; quot;vacationquot; gt; wrote:
gt;
gt; gt; The following formula gives me a zero result :
gt; gt; =SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
gt; gt;
gt; gt; I want to count all occurences of valuesgt;$0.00 in Column F only if column
gt; gt; B=Joe in a filtered list.
gt; gt;
gt; gt; Thank you
gt;