How do I count number of cels the matches 2 conditions (I am using COUNTIF
and AND) ??? I need the total of cels that matches the 2 conditions and not
the sum of the cels.
Thanks
How do I count number of cels the matches 2 conditions (I am using COUNTIF
and AND) ??? I need the total of cels that matches the 2 conditions and not
the sum of the cels.
Thanks
=SUMPRODUCT(--(A1:A100="value1"),--(A1:A100="value2"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Abra" <[email protected]> wrote in message
news:[email protected]...
> How do I count number of cels the matches 2 conditions (I am using COUNTIF
> and AND) ??? I need the total of cels that matches the 2 conditions and
not
> the sum of the cels.
> Thanks
You could use Countif() in conjunction with Sum() to count against any
number of conditions:
=SUM(COUNTIF(A1:A100,{"cond#1","cond#2","cond#3"}))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Abra" <[email protected]> wrote in message
news:[email protected]...
> How do I count number of cels the matches 2 conditions (I am using COUNTIF
> and AND) ??? I need the total of cels that matches the 2 conditions and
not
> the sum of the cels.
> Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks