| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
suming every 3rd column
Hello Pete from Steved
Thankyou "Pete_UK" wrote: The 109 only works for hidden rows, not hidden columns unfortunately. Pete "Gaurav" wrote in message ... =SUBTOTAL(109,J3:AQ3) "Steved" wrote in message ... 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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| testing while suming | New Users to Excel | |||
| suming in add-ins | Excel Worksheet Functions | |||
| Suming values from a xls file | Excel Worksheet Functions | |||
| Suming up a Lookup | Excel Worksheet Functions | |||
| Suming 2 cells if 1 = #N/A | Excel Worksheet Functions | |||
Threaded Mode
