Question description:
This user has given permission to use the problem statement for this
blog.
I have if statements =IF(E16="n/a", "n/a", "10") in C:13 to C:28. I want to sum if the cell does not have n/a
Solved by S. F. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/04/2018 - 02:16
Hello
Excelchat Expert
03/04/2018 - 02:16
How are you?
User
03/04/2018 - 02:16
other
User
03/04/2018 - 02:16
is this free
Excelchat Expert
03/04/2018 - 02:17
Could you please run me through your problem?
User
03/04/2018 - 02:18
I want to sum the values in column not equal to n/a
Excelchat Expert
03/04/2018 - 02:18
Alright, which cell would you like to place the sum formula?
User
03/04/2018 - 02:19
the fields already have an if statement based on what is selected in another cell
User
03/04/2018 - 02:19
it would be column b
Excelchat Expert
03/04/2018 - 02:19
Okay, the total would be on cell B19... correct?
User
03/04/2018 - 02:20
yeah
User
03/04/2018 - 02:20
can you confimr if this is free or not
Excelchat Expert
03/04/2018 - 02:20
okay, i think you are provided a free trial for this session
User
03/04/2018 - 02:20
ok
User
03/04/2018 - 02:21
i tried so many formulas i cannot figure this out
Excelchat Expert
03/04/2018 - 02:22
okay, please give me a moment to figure this out
User
03/04/2018 - 02:23
ok
Excelchat Expert
03/04/2018 - 02:24
I think i know where your problem lies
User
03/04/2018 - 02:25
ok
Excelchat Expert
03/04/2018 - 02:25
please notice that your formula in row B
Excelchat Expert
03/04/2018 - 02:25
enclosed the resulting numbers in ""
Excelchat Expert
03/04/2018 - 02:26
excel will evaluate this as text instead of numbers, that is why you cannot perform mathematical operations on them
Excelchat Expert
03/04/2018 - 02:26
if I may suggest, please look at the edits i will be making on your spreadsheet
User
03/04/2018 - 02:27
ok
User
03/04/2018 - 02:27
so one I remove "" from the numbers
User
03/04/2018 - 02:27
which formula should I ust to sume it
Excelchat Expert
03/04/2018 - 02:27
yes
Excelchat Expert
03/04/2018 - 02:28
=sumif
User
03/04/2018 - 02:28
=sumif(Range,>)
User
03/04/2018 - 02:28
0)
Excelchat Expert
03/04/2018 - 02:28
=sumif(B3:B18,"<>n/a")
Excelchat Expert
03/04/2018 - 02:29
you must note though that "n/a" is also evaluated as text
User
03/04/2018 - 02:29
got it
Excelchat Expert
03/04/2018 - 02:29
but if your original intention is to add values on the cells excluding #N/A errors
Excelchat Expert
03/04/2018 - 02:30
your SUMIF formula will be modified
User
03/04/2018 - 02:30
ok, thanks for your help
Excelchat Expert
03/04/2018 - 02:30
you're welcome
Excelchat Expert
03/04/2018 - 02:31
is it okay if I mark this problem "Solved"?
User
03/04/2018 - 02:31
yes
Excelchat Expert
03/04/2018 - 02:31
Great!
Excelchat Expert
03/04/2018 - 02:31
Thanks again. and see you next time :) Please don't forget to rate.
User
03/04/2018 - 02:32
will do, thanks'
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.