Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to use the CountSum funtion of worksheet in Macros

I need to count the sumn of values present in a column or row using Excel
macros.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default How to use the CountSum funtion of worksheet in Macros

Hi:

there is no need to use a macro in this situation just use the following:

=sum(a:a) if the whole column or

=sum(a1:a20) if a range.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"saraveenan" wrote:

I need to count the sumn of values present in a column or row using Excel
macros.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros in Excel Worksheet dknorwood Excel Discussion (Misc queries) 7 July 13th 06 03:05 AM
worksheet funtion help Richard Excel Discussion (Misc queries) 2 July 11th 06 04:09 PM
list worksheet macros/VBA without adding worksheet br549 Excel Discussion (Misc queries) 0 January 6th 06 10:17 PM
Is is possible to run macros on a protected worksheet petunia Excel Worksheet Functions 1 January 18th 05 04:55 PM
Help with setting up a worksheet funtion mjh Excel Worksheet Functions 2 November 11th 04 10:06 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"