There are several values and their subtotals in a column. Those values and subtotal reference may be added or deleted. Then at last there is a cell in the column which is grand total. I want to know is there any method by which I can calculate the grand total of the cells in the columns which contains formula. Because presently I may skip some cells which should be included while calculating grand total or some cells references are given to calculate grand total which are not expected to be there.
As there is a function ISFORMULA() you may use it in a SUMPRODUCT to get only values from fields with formula.
https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISFORMULA
1 Like
=SUMPRODUCT(ISFORMULA(A1:A7)*A1:A7) solves my problem.
2 Likes