#1   Report Post  
Steved
 
Posts: n/a
Default Value 0

Hello from Steved

=SUMPRODUCT(--($B$4:$B$15="1"),($C$4:$C$15="P"),$H$4:$H$15))

is returning a 0 value

What Have I done wrong please.

Thankyou.
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

Maybe get rid of the quotes around the 1?

If 1 is supposed to be a number, the quotes make it text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steved" wrote in message
...
Hello from Steved

=SUMPRODUCT(--($B$4:$B$15="1"),($C$4:$C$15="P"),$H$4:$H$15))

is returning a 0 value

What Have I done wrong please.

Thankyou.


  #3   Report Post  
Biff
 
Posts: n/a
Default

In addition to RD's suggestion....

There is one too many closing ")" at the end of the formula. Also, using the
double unary syntax, you're missing a set before the second array:

=SUMPRODUCT(--($B$4:$B$15=1),--($C$4:$C$15="P"),$H$4:$H$15)

That should do it!

Biff

"RagDyer" wrote in message
...
Maybe get rid of the quotes around the 1?

If 1 is supposed to be a number, the quotes make it text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steved" wrote in message
...
Hello from Steved

=SUMPRODUCT(--($B$4:$B$15="1"),($C$4:$C$15="P"),$H$4:$H$15))

is returning a 0 value

What Have I done wrong please.

Thankyou.




  #4   Report Post  
Steved
 
Posts: n/a
Default

Thankyou.

"Biff" wrote:

In addition to RD's suggestion....

There is one too many closing ")" at the end of the formula. Also, using the
double unary syntax, you're missing a set before the second array:

=SUMPRODUCT(--($B$4:$B$15=1),--($C$4:$C$15="P"),$H$4:$H$15)

That should do it!

Biff

"RagDyer" wrote in message
...
Maybe get rid of the quotes around the 1?

If 1 is supposed to be a number, the quotes make it text.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steved" wrote in message
...
Hello from Steved

=SUMPRODUCT(--($B$4:$B$15="1"),($C$4:$C$15="P"),$H$4:$H$15))

is returning a 0 value

What Have I done wrong please.

Thankyou.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"