No but you can use SUMPRODUCT,
assume you want to count values in A1: A10 that are greater than 5 and has
the colour red in B1: B10
=SUMPRODUCT(--(A1:A105),--(B1:B10="red"))
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"blake7" wrote in message
...
I want to use the countif function in excel to look at one criteria in one
column and another criteria in another before summing up, can this be done
?