Hello again my saviors,
I have a fairly sprawling worksheet that has a large variety of items as the
rows, and then the columns are months, so each item is broken down by month
in terms of volume sold. There are also columns after each 3 months for the
quarters which sum the numbers for each month, and a YTD one at the end that
sums the quarters. Also, the rows of items are grouped by type, so after
each grouping there are rows that subtotal that type, and then at the end
total the subtotals. So there are raw data cells which contain raw numbers
pulled from elsewhere, and interwoven are rows & columns of simple sum
formulas.
Question (finally):
I've copied this whole table onto a new worksheet, but I want to change all
the sum formulas to average formulas. But not all the sum formulas are
adding the same amount of items (i.e. one type may have 3 items & another 6,
YTD sums 4 quarters whereas quarters sum 3 months). Is there a formula to
change the additions to averages? One that would determine the number of
'things' that particular function is adding so it would know the right
divisor to use?

Thanks in advance!