Count manually entered values in a range of cells and ignore the values generated by forumla

[sashapixie]

Hi There

I am trying to work out how I can count manually entered values in a range of cells and ignore the values generated by formula.

Any ideas?

Thanks

 

[Mike LH]

Hi,

Try this


=SUMPRODUCT((A1:A20<>"")*(NOT(ISFORMULA(A1:A20))))

 

[galt13]

Are you only entering numbers or is there text also?

 

[sashapixie]

Thanks mike works a treat

 

[sashapixie]

Do you know how I would sum this instead of count?

 

[sashapixie]

I have solved this using the sum and offset formulas in a separate cell

 

[Mike LH]

Hi,

Provided there's no text in the range, I'd do it like this


=SUMPRODUCT((ISNUMBER(A1:A20))*(NOT(ISFORMULA(A1:A20)))*(A1:A20))