• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula result not showing in cell...only shows zero

F

footballfan

New Member
Hello. In excel 2010 I've come across an issue where I have input a formula in a cell(e.g.=SUMIF(BR90:BR718,1,$S$90:$S$718); however, the result in the cell is always zero. The odd part is that when you look at the formula in the function arguments box it shows the actual result (in this case 24676).


Why isn't the actual result showing in the cell?


Thank you.
 
You must log in or register to reply here.
Back
Top