And these are the words Red and Blue--not the actual colors, right?

=sum(countif(a1:a25,{"Red","Blue"}))

or you could each separately:

=countif(a1:a25,"Red") + countif(a1:a25,"blue")



Karen wrote:

Let's say I have a range of data from A1:A25 and I want to use the COUNTIF
function to count how many times 2 different conditions fall within this
range. The conditions are "Red" and "Blue" - What would the formula be? I'm
assuming I use the COUNTIF function.

ANY help would be greatly appreciated, Karen

--

Dave Peterson