If Function returning 0 instead of cell value

  • Thread starter Thread starter torana_girl77
  • Start date Start date
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.
 
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
 
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
struggling with if logical test function 2
Excel formula, sum the value cell and if empty cell left blank 0
Total Working hours If 2
Counting using two sets of criteria Harlon, JE< Anyone?? 1
Calculation / Format Error 1
IF Function error #VALUE 2
If statement not returning the value i need 6

Back
Top