SUM a range of cells without a formula inputted?

[caf20012]

Hi,

I'm trying to calculate the total value of cells: A1:A5.

A1:A3 has a formula inputted into the cells and A4:A5 has manual values entered into the cells.

Is there a formula to only SUM the cells with manual values entered into them from range A1:A5. This is so if i update a cell with a formula inside it, It will update.

Example: If i update update cell A2 then the total value changes as this isn't a formula anymore.

Kind regards,

caf20012.

[:) Sixthsense :)]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

In Excel Try like this…

=SumInputs(A2:A11)

[caf20012]

Thank you so much!!!