If Function returning 0 instead of cell value

T

torana_girl77

I have entered this statement =SUM(IF(DataEntry!$O38=$A$1,DataEntry!F38)). I
know that it is correct as it is returning the correct infromation. the
problem is that it is returning a 0 for anything with text in it but will
return the correct inforamtion for date or $100. i.e. if F38 is hello
friends it returns 0 but if F38 is $100 it returns $100 please tell me how i
can get the text to show up.

thank you.
 
T

T. Valko

You don't need/want the SUM function.

=IF(DataEntry!$O38=$A$1,DataEntry!F38,"")
 
C

Conan Kelly

torana_girl77,

You can't SUM text...you can only SUM values...ie. numbers, dates/times,
dollar amounts, etc.

T. Valko's response is correct. By the looks of your formula, there should
be no need for the SUM() function.

HTH,

Conan Kelly
 
T

torana_girl77

Thank you that did the trick - now that you have said it i don't know why i
didn't think of it. thank you so much i was getting very annoyed.
 

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

if function shows 0 instead of blank 6
Problem with SET & REF function 0
struggling with if logical test function 2
IF Function error #VALUE 2
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b 2
Use TODAY() function as the criteria in a SUMIF formula 1
Nested IF Function not working 11
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0

Top