COUNTIF
Thank you for your help
Karen
" wrote:
On Oct 31, 8:44 am, 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
Try...
=COUNTIF(A1:A25,"Red")+COUNTIF(A1:A25,"Blue")
or
=SUM(COUNTIF(A1:A25,{"Red","Blue"}))
Hope this helps!
|