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!
That answer does not help me anything.
Last edited by Kaitolito; 07-20-2018 at 02:12 AM.
click on link and read description about SUMIF or SUMIFS , how they works and how to use
That answer doesn't help me anything.
pity, have a nice day
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.
Try
Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I just used this formula;
Formula:Please Login or Register to view this content.
And it gave me 90 as the result.
@avkOriginally Posted by Kaitolito
the question is how to skip the other columns (D,F,etc)
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
the original post already stated
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.
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.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks