# SUMIF problem

1. ## SUMIF problem

Hey boys, i am trying and trying and trying to make the SUMIF formula work. But i can't. So now i'm asking you, for help.

Here is the problem:

Example.PNG

I would like to sum Column 2, 4, 6 and 8 IF the actual cell does NOT contain N/A.

I am trying something like this: =SUMIF(C2,E2,G2,I2,"<>N/A",C2,E2,G2,I2) but it just doesn't work. Can anyone help me out here?

Thank you so much!

2. ## Re: SUMIF problem

Funktionen SUMMA.OM

SUMMA.OMF funktionen

3. ## Re: SUMIF problem

That answer does not help me anything.

4. ## Re: SUMIF problem

click on link and read description about SUMIF or SUMIFS , how they works and how to use

5. ## Re: SUMIF problem

That answer doesn't help me anything.

6. ## Re: SUMIF problem

pity, have a nice day

7. ## Re: SUMIF problem

I have already done that, and they does not cover how to use the formula on cells that are not next to each other on a row. That's the problem.

8. ## Re: SUMIF problem

Try
Formula:
`Please Login or Register  to view this content.`

9. ## Re: SUMIF problem

I just used this formula;
Formula:
`Please Login or Register  to view this content.`

And it gave me 90 as the result.

10. ## Re: SUMIF problem

Originally Posted by Kaitolito
they does not cover how to use the formula on
cells that are not next to each other on a row
@avk
the question is how to skip the other columns (D,F,etc)

11. ## Re: SUMIF problem

No, but given the sample data, it doesn't matter - those columns are empty. This is why it's so important to provide realistic sample data - I imagine that in the real data they do contain data. Members here will offer solutions based on what they are given, not missing details.

It's a bit late now, but the title to this thread is very vague. Titles should be more descriptive of the problem.

12. ## Re: SUMIF problem

which 4 columns are to be added up
-- implying we should skip data
in any other columns.

for those who missed this implication,
OP came back in post #7 and stated it explicitly.

13. ## Re: SUMIF problem

Yes, so why did the OP not provide sample data that matched the requirement? The visuals and the written requirement don't match - that's my point.

This is why it takes so long sometimes to reach what could have been a quick resolution. My comments are really for the OP to consider, and not meant as a criticism of any helpers in this thread.

14. ## Re: SUMIF problem

This works (it ignores that N/A entries):

=SUM(C2,E2,G2,I2)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1