PDA

View Full Version : Solved: countifs in excel 2003



nbqleebarnes
06-30-2009, 10:44 PM
Hi All,
I'm busy trying to code the equivelant code in excel 2007 for
=COUNTIFS($C$7:$C$599,"quality",$H$7:$H$599,"g")

I have tried using
=SUMPRODUCT(--($C7:$C599="supplier"),--($H7:$H599="g"))
in excel 2003 but I don't seem to get it right.
Can anyone help
Thanks
Lee

anandbohra
06-30-2009, 11:00 PM
Try this

=SUMPRODUCT(($C$7:$C$599="supplier")*($H$7:$H$599="g"))

GTO
06-30-2009, 11:02 PM
Hi Lee,

I still forget proper use of SP faster than heck, but what is the above not doing. Seems to add okay for me.

Mark

nbqleebarnes
06-30-2009, 11:27 PM
Hi Mark,
Did eventually get it with
=SUMPRODUCT(($C$7:$C$599="supplier")*($H$7:$H$599="g"))
Thanks very much works fine now
Cheers
Lee

GTO
06-30-2009, 11:52 PM
I'm glad anadbohra's suggestion worked :bow:

(Back to reading about SP for me :blush )


Cheers to you also,

Mark

Bob Phillips
07-01-2009, 12:58 AM
There is no obvious reason that your formula does not work but the alternative does.

Can you post the workbook so that we can track down why?

nbqleebarnes
07-01-2009, 03:49 AM
Hi XLD,
Tried the same formula again after fixing my workbook references and I had made a mistake with my workbook, both of the formulas do infact work.
=SUMPRODUCT(($C$7:$C$599="supplier")*($H$7:$H$599="g"))
and
=SUMPRODUCT(--($C7:$C599="supplier"),--($H7:$H599="g"))

Thanks