Countif Statement

[kmrowlan]

I have a sheet where I need to do multiple countif statements. It is not an issue for me since I have 2007 but there are others within my company that have 2003. How can I write this statement where it will function inside 2003?

=COUNTIFS($B$4:$B$118,I123,$F$4:$F$118,"OUT")

I have tried sumproduct and sum(if statements but have not had any luck

Thanks

Kevin

 

[T. Valko]

I have a sheet where I need to do multiple countif statements. It is not an issue for me since I have 2007 but there are others within my company that have 2003. How can I write this statement where it will function inside 2003?

=COUNTIFS($B$4:$B$118,I123,$F$4:$F$118,"OUT")

I have tried sumproduct and sum(if statements but have not had any luck

Thanks

Kevin

Try this...

=SUMPRODUCT(--($B$4:$B$118=I123),--($F$4:$F$118="OUT"))

 

[kmrowlan]

Thank you for the help

 

[T. Valko]

Thank you for the help

You're welcome!