Ignoring specific number

P

patatwork

Okay I am try to sum up half a row and subtract away the other half of
row. It is a coding scheme however and I want excel to ignore every tim
there is a 99, so pretend it is a 0 in other words, but there is to
much data to change them all to 0. Thanks in advance for your help
 
C

Claus Busch

Hi,

Am Thu, 6 Jun 2013 19:29:11 +0100 schrieb patatwork:
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.
Click to expand...

try:
=SUMIF(A1:H1,"<>99",A1:H1)-SUMIF(I1:p1,"<>99",I1:p1)


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
Searching for non-consecutive text 3
Cumulative formula for word table 0
Auto Merge text from multiple sources 0
Separting negative numbers from letters in cells 1
Document Merge Formatting Issue 0
VBA Export to PDF 0
Adding a big matrix in Word 2013 5

Top