Re: COUNTIF function for 'all others'
- From: "JulieD" <JulieD@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 2 Apr 2005 01:44:17 +0800
Hi
how about
=COUNTA(A1:A6)-sum(B1:B3)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"terrapinie" <terrapinie@xxxxxxxxx> wrote in message
news:1112376038.115660.302790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have a column to count the number of occurrences of certain statuses.
> And have set up the COUNTIF function for three of the status lables,
> and I want to have the fourth to count the number of items with any
> other status.
> For example
> A B
> 1 III COUNTIF(A1:A6,"III")
> 2 XXX COUNTIF(A1:A6,"XXX")
> 3 VVV COUNTIF(A1:A6,"OOO")
> 4 III COUNTIF(AI:A6,"anything else")
> 5 OOO
> 6 NNN
>
> and B1=2, B2=1, B3=1, B4=2.
>
> Is this possible, and how do I do it?
> If need be, I could set it up to be COUNTIF(A1:A6, does not equal
> "III","OOO","XXX")
>
> But I don't know how to do that either...
>
> Thanks a ton in advance!!
> Laurie
>
.
- References:
- COUNTIF function for 'all others'
- From: terrapinie
- COUNTIF function for 'all others'
- Prev by Date: COUNTIF function for 'all others'
- Next by Date: Multiple lines in a single cell
- Previous by thread: COUNTIF function for 'all others'
- Next by thread: Re: COUNTIF function for 'all others'
- Index(es):
Relevant Pages
|
