Try this:
=SUMPRODUCT(--(B:B="2c"),--(D:D="adventure"))
Jonhart75 Wrote:
Hi I am try to use a countif command to display results of 2 diferent
variables
I have two coloums b and d and want to display the results as a count
if b =
2c and d = adventure
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=390281