| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a Formula
I have only two different text throughout column "K" say.. red apple or blue
apple and I need to find out how many red apples and then how many blue. Is there a formula for this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for a Formula
=COUNTIF(K1:K10,"red apple")
=COUNTIF(K1:K10,"blue apple") "mugwump" wrote in message ... I have only two different text throughout column "K" say.. red apple or blue apple and I need to find out how many red apples and then how many blue. Is there a formula for this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for a Formula
Try these:
=COUNTIF(K:K,"red apple") =COUNTIF(K:K,"blue apple") -- Biff Microsoft Excel MVP "mugwump" wrote in message ... I have only two different text throughout column "K" say.. red apple or blue apple and I need to find out how many red apples and then how many blue. Is there a formula for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
