COUNTIFS in Excel 2003?

[Bench]

Hi,

I worked out a solution to an issue i've had with an exel spreadsheet using the COUNTIFS, however when i've got to work we don't have excel 2007 and i've realised now that there is no COUNTIFS function in '03

Is there an add in that can be added to excel 03 or a function that can be vba'd?

These are my formulas:

=COUNTIFS(H:H,"rbs",I:I,"<4")
=COUNTIFS(H:H,"rbs",I:I,"=4")
=COUNTIFS(H:H,"rbs",I:I,">4")

Any help would be appreciated

 

[RoryA]

Welcome to the forum.

It would be:

=SUMPRODUCT((BC33:BC232="this month")*(J33:J232="Connect"))

 

[Belli]

Welcome to the forum.

It would be:

=SUMPRODUCT((BC33:BC232="this month")*(J33:J232="Connect"))

Thank you so much. It works properly.