I am trying to divide values from column B by values in column D (some of which are blank cells), then values in column B by values in column E, and so on. I am also trying to then divide the total for each column by the number of non-empty cells in the column.
So I am trying to do this B1/D1+B2/D2+B3/D3.../count(d1:d48); B1/E1+B2/E2+B3/E3.../count(e1:e48)..etc..
Despite numerous attempts I continue to get a #div/0 result. Note that column B will always have a value -- it is columns D, E, F...R which may include empty cells.
=SUMPRODUCT(($B$1:$B$48)/(D1:D48))/COUNT(D1:D48)
--example---
row | column B | column D | column E | column F....R
1 .25 1 3 1
2 .28 1 2
3 .38 3 5
4 .12 2 4
5 .17 4
6 .33 1 2 4
Can someone please help me with this, I have spent the last several hours trying to figure this out. I would sincerely appreciate any help...
Bookmarks