On 4/23/2016 2:33 PM, Claus Busch wrote:
Hi Mike,
Am Sat, 23 Apr 2016 13:49:23 -0700 schrieb Mike S:
=(I9-H9)+(L9-K9)+(O9-N9)+(R9-Q9)
If I change L, K, O, N, R, Q to text is there a way to add just
I-H to
the balance and ignore text entries that I can paste into the
balance
column formula?
the function SUM ignores text.
Try:
=SUM(IF(MOD(COLUMN(H9:R9),3)=0,H9:R9))-SUM(IF(MOD(COLUMN(H9:R9),3)=2,H9:R9))
and insert the formula with CTRL+Shift+Enter
Regards
Claus B.
GS and Claus,
Changing the numeric entry columns to general, entering "EX" where
needed, then using SUM worked perfectly. Sum ignores non-numric as
advertised and does the math correctly... no more #VALUE cells
shouting at me from the page! I had no idea SUM worked that way.
Thank you very much!
Mike
Glad to be some help...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus