Solved: countifs in excel 2003

[nbqleebarnes]

Hi All,
I'm busy trying to code the equivelant code in excel 2007 for
[vba]=COUNTIFS($C$7:$C$599,"quality",$H$7:$H$599,"g")[/vba]

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

[anandbohra]

Try this

[VBA]=SUMPRODUCT(($C$7:$C$599="supplier")*($H$7:$H$599="g"))[/VBA]

[GTO]

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]

Hi Mark,
Did eventually get it with
[VBA]=SUMPRODUCT(($C$7:$C$599="supplier")*($H$7:$H$599="g"))[/VBA]
Thanks very much works fine now
Cheers
Lee

[GTO]

I'm glad anadbohra's suggestion worked

(Back to reading about SP for me )


Cheers to you also,

Mark

[Bob Phillips]

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]

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.
[VBA]=SUMPRODUCT(($C$7:$C$599="supplier")*($H$7:$H$599="g"))[/VBA]
and
[VBA]=SUMPRODUCT(--($C7:$C599="supplier"),--($H7:$H599="g"))[/VBA]

Thanks