| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif + average over12mths, then removing the avearge on 12mth
I have 13 columns of data 1-12mths the first column calculates the totals of
mths 1 to 12. When I entre data say the 1st 4mths I need the 1st colum to read the total actal spend and average so we can predict over/under spend befor the year end. This bit I have achieved. PROBLEM when I get to the 12th month I want the formula to just look at the actual spend and not include the aveage. Can this be done in one formula if so how Thanks Amy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF for an AVERAGE | Excel Worksheet Functions | |||
| Average/Sumif based on several columns | Excel Worksheet Functions | |||
| Average/Sumif based on several columns | Excel Worksheet Functions | |||
| Weighted average using SUMIF and/or SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
Threaded Mode
