| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas autofill ok but continues to carry tot from 1st column??
I have been using the Sum and Subtotal function on my spreadsheet for a year
with no problem. All of a sudden when I change my formula to include additional lines or use the filter, the formulas are no longer working. It autofills correctly, but carries the total from the 1st column all the way across and does not change when I change the filters unless I click in the formula bar for each column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
