LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 519
Default suming every 3rd column

Hello from Steved

Looking at the below I hide 2 Colums for example K and L Columns and so on

Is there please a Sum function I can use to sum colums but ignore the hidden
columns.

=J3+M3+P3+S3+V3+Y3+AB3+AE3+AH3+AK3+AN3+AQ3

Thankyou.
 
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
testing while suming angryelvis New Users to Excel 3 August 14th 07 05:58 PM
suming in add-ins ajimmo Excel Worksheet Functions 2 October 2nd 06 11:57 PM
Suming values from a xls file southerndandy Excel Worksheet Functions 3 December 21st 05 04:24 PM
Suming up a Lookup Byan Excel Worksheet Functions 1 July 21st 05 09:36 PM
Suming 2 cells if 1 = #N/A carl Excel Worksheet Functions 3 June 10th 05 08:41 PM


All times are GMT +1. The time now is 10:05 PM.

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"