Dear All Experts
Thank you very much all to proper guidance about Countif formula
Regards
Amar
On Sat, Apr 6, 2013 at 2:20 PM, prafull jadhav wrote:
>
> Dear Amar,
>
> These both formula is same ..when you use the countif function then use
> =COUNTIF($F$3:$F$74,B3)
> and if there is multiple c
Dear Amar,
These both formula is same ..when you use the countif function then
use =COUNTIF($F$3:$F$74,B3)
and if there is multiple condition while counting then use
countifsfunction then you have to write formula like
=COUNTIF($F$3:$F$74,"="&B3)
find the attachment I have mentioned the examples
acros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Countif Formula Logic
When you use "=", "<", ">" with countif, you need to use "&". I think
so...not sure.
On Sat, Apr 6, 2013 at 1:46 PM, amar takale wrote:
Dear Experts
what is Different between t
Hi Amar ,
There is no difference between these formulas.if u have any doubt please
mention your query with example.
Regards,
Priti Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 06 April 2013 1:47
To: excel-macros@googlegroups.
When you use "=", "<", ">" with countif, you need to use "&". I think
so...not sure.
On Sat, Apr 6, 2013 at 1:46 PM, amar takale wrote:
> Dear Experts
>
> what is Different between two formulas bcos from this formula I got same
> answer.So what is logic of "="&
>
> =COUNTIF($F$3:$F$74,"="&B3)
>
