Forum Discussion
Rawle Mars
Aug 05, 2020Copper Contributor
Subtotals and Grand totals
I have numbers that range from B3 to B53 and a subtotal =subtotal(9,b3:b53) in B54. I have another set of numbers from B58 to B180 and a subtotal =subtotal(9,b58:b180) in B181. In B 186 I have the ...
- Aug 05, 2020
Ramiz_Assaf
Aug 05, 2020Iron Contributor
=SUMPRODUCT((ISFORMULA(B3:B180)=FALSE)*B3:B180)
found it here
https://stackoverflow.com/questions/55803385/sumif-cells-are-not-formulas
found it here
https://stackoverflow.com/questions/55803385/sumif-cells-are-not-formulas