sumproduct returns zero
 

The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

Thank you

sumproduct returns zero
 

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

=SUMPRODUCT((B2:B18="joe")*(F2:F180))

or

=SUMPRODUCT(--(B2:B18="joe"),--(F2:F180))

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

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"vacation" wrote in message
...
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

Thank you

sumproduct returns zero
 

"vacation" wrote in message
...
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

It should be:

=SUMPRODUCT((B2:B18="joe")*(F2:F180))

Bruno

sumproduct returns zero
 

Remove the quotes for your second condition...

=SUMPRODUCT((B2:B18="Joe")*(F2:F180))

For a filtered list, try the following...

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(B2:B18,ROW(B2:B18)-ROW(B2),0,1))),--(B2:
B18="Joe"),--(F2:F180))

Hope this helps!

In article ,
"vacation" wrote:

The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

Thank you

sumproduct returns zero
 

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

"Ken Wright" wrote:

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

=SUMPRODUCT((B2:B18="joe")*(F2:F180))

or

=SUMPRODUCT(--(B2:B18="joe"),--(F2:F180))

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

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------



"vacation" wrote in message
...
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

Thank you

sumproduct returns zero
 

Thank you very much! It works!

"Bruno Campanini" wrote:

"vacation" wrote in message
...
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

It should be:

=SUMPRODUCT((B2:B18="joe")*(F2:F180))

Bruno

sumproduct returns zero
 

You're very welcome :-)

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

"vacation" wrote in message
...
Thank you so much! I have been working on this for months.

"Ken Wright" wrote:

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

=SUMPRODUCT((B2:B18="joe")*(F2:F180))

or

=SUMPRODUCT(--(B2:B18="joe"),--(F2:F180))

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

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"vacation" wrote in message
...
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

Thank you

sumproduct returns zero
 

Thank you, that was fast.

"Domenic" wrote:

Remove the quotes for your second condition...

=SUMPRODUCT((B2:B18="Joe")*(F2:F180))

For a filtered list, try the following...

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(B2:B18,ROW(B2:B18)-ROW(B2),0,1))),--(B2:
B18="Joe"),--(F2:F180))

Hope this helps!

In article ,
"vacation" wrote:

The following formula gives me a zero result :
=SUMPRODUCT((B2:B18="joe")*(F2:F18"0"))

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

Thank you