*Hi Habeeb,*
To get the flexibility, use the following formula:-
=SUMPRODUCT((A3:A65536="Sub Total")*(B3:B65536))
Thanks & Regards,
Dilipandey
On Fri, May 15, 2009 at 10:04 AM, Habeeb Mohammed wrote:
> Hi Guys,
>
> I currently written a code were in total will be populated by adding
> various su
Type the belomentioned line next to total cell
=SUMIF($A$1:$A$10,"Sub Total",B1:B10)
-Original Message-
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of Habeeb Mohammed
Sent: Thursday, May 14, 2009 9:34 PM
To: excel-macros@googlegroups.com
Subjec
Hi Dave,
I got it now... Any way i need to put in a code for dynamically changing the
range and can do it
Thanks a lot
Regards
Habeeb
From: davebonall...@hotmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: formula in macros
Date: Fri, 15 May 2009 17
Hi Habeeb,
Have a look at the attached, and see if it does what you need.
Regards - Dave.
From: habeebc...@hotmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ formula in macros
Date: Fri, 15 May 2009 04:34:26 +
Hi Guys,
I currently written a code were in total
