**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.*