Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Ignoring specific number
9 views
Skip to first unread message
patatwork
Jun 6, 2013, 2:29:11 PM6/6/13
to
Okay I am try to sum up half a row and subtract away the other half of a
row. It is a coding scheme however and I want excel to ignore every time
there is a 99, so pretend it is a 0 in other words, but there is too
much data to change them all to 0. Thanks in advance for your help.
--
patatwork
Claus Busch
Jun 6, 2013, 2:56:38 PM6/6/13
to
Hi,
try:
=SUMIF(A1:H1,"<>99",A1:H1)-SUMIF(I1:P1,"<>99",I1:P1)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
=SUMIF(A1:H1,"<>99",A1:H1)-SUMIF(I1:P1,"<>99",I1:P1)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0 new messages