For insurance try this change in O4:O11. The blanks were returning 1s. This will return 0s. Then change the formula B4:M4 to this The N function converts strings and blank cells to zeros. That was the problem. However N is resistant to accepting whole ranges. The range has to be coerced into an array. That is what the + is about.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
2 |
Fork Lagoon |
Jan-18 |
Feb-18 |
Mar-18 |
Apr-18 |
May-18 |
Jun-18 |
Jul-18 |
Aug-18 |
Sep-18 |
Oct-18 |
Nov-18 |
Dec-18 |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
Revenues [Internal] |
0 |
3000 |
9000 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Bookmarks