Hi Ramesh,
You need to freeze the data range and them move down.
=countif($a$2:$a$10,"M").
Use F4 key in formula to freeze (Lock) the cell references.
Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Hi,
Keep the range fixed, countif($a$2:$a$10,"M") should work with M or F.
Sri
On Sun, Jun 7, 2009 at 5:24 PM, Ramesh Katta wrote:
> Dear Members,
>
> My question seems to be very simple, please don't laugh at me.
>
> I have 2 columns that are A1 contains Names and B1 contains Sex of
> employe
dear ramesh,this is because u are dragging the cell downward for using same
formula...
if u want to drag the cell downwards without changing the data range pls
make use of "$" sign eg- =COUNTIF(B$2:B$11,"F")
hope ur doubt is clear..
MANOJ N KARATE.
Sub Engineer (Roads) W.S.
Municipal Corporation of
Hi Ramesh,
Please checkout the file attached with sollution.
Vinayak Hegde
From: Ramesh Katta
To: excel-macros@googlegroups.com
Sent: Sunday, 7 June, 2009 5:24:38 PM
Subject: $$Excel-Macros$$ Doubt on data range
Dear Members,
My question seems to be very s
Hi, Narendra,
Thank you very much for helping on time.
Regards
Ramesh
On Sun, Jun 7, 2009 at 8:13 PM, CA NARENDRA
ASHARA wrote:
> Dear Ramesh,
>
> You need to freeze the range by F4. Please find the solution in the attached
> sheet.
>
> Thanks & Regards,
> Narendra
>
> -Original Message
Hi Ramesh,
The formulas should be:
=countif($a$2:$a$10,"M")
=countif($a$2:$a$10,"F")
Then you can paste them anwhere on the sheet and get the same answer.
Without the $ signs, the range reference will change depending on where you
paste the formula.
Regards - Dave.
> Dear Membe
Dear Ramesh,
You need to freeze the range by F4. Please find the solution in the attached
sheet.
Thanks & Regards,
Narendra
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ramesh Katta
Sent: 07 June, 2009 5:25 PM
To: excel-macros
