Changing Countifs to a 2003 compatible function

[rgirardi]

Hi
I wrote some formulas using the countifs function in excel 2010, however some of my coworkers only have excel 2003. What function could I replace the countifs with. Would it be a one ot one replacement?

The formulas are below:
=COUNTIFS('Records Created'!$BP:$BP,"Deviation",'Records Created'!E:E,"Critical")
=COUNTIFS('Records Created'!$BP:$BP,"Deviation",'Records Created'!E:E,"Major")
=COUNTIFS('Records Created'!$BP:$BP,"Deviation",'Records Created'!E:E,"Minor")

Thanks

[Richard Buttrey]

Hi,

Probably a SUMPRODUCT() function, but I suggest you limit the ranges to just the rows you need e.g

=SUMPRODUCT(('Records Created'!$BP1:$BP100="Deviation")*('Records Created'!E1:E100="Critical"))

[rgirardi]

Hi that worked on those, but this one is not cooperating when I try to convet it.
=COUNTIF('Capa ontime '!BO:BO,"CAPA")/COUNTIFS('Capa ontime '!BO:BO,"CAPA",'Capa ontime '!CN:CN,"<>Closed - Done",'Capa ontime '!CN:CN,"<>Complete")*0.1

[Richard Buttrey]

Hi,

You'll need to show us how you've converted your function to the SUMPRODUCT() version