I need a formula so I can SUM an array of columns or rows except dates.
BTW, Thanks in advance. :-)
| | a | b | c | d | e | f | g | h | i |
| 1 | Date | 1st Installment | Date | 2nd Installment | Date | 3rd Installment | Date | 4th Installment | Total Collection |
| 2 | 1-mar-2019 | 2000 | 4-Apr-2019 | 2000 | 1-May-2019 | 3000 | 15-Jun-2019 | 1000 | = SUM ( ???? ) |
BTW, Thanks in advance. :-)
| Date |
| Date |