Hello, I have a sheet (not created by me) that uses a sumif formula to get the yearly numbers (column EA) from the monthly numbers. For some reason, the yearly numbers are not adding up and I'm not sure why. I think it has to do with the fact that I haven't put in data for all of the months. Is there a way to get around this? I've attached a sample spreadsheet. Thanks.
HI amartino,
See the attached file.. cell EA10 (highlighted yellow) where I have enhanced the formula as :-
Formula:
Please Login or Register to view this content.
Book2(10).xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Thanks. It looks like the only difference between your formula and the one in the sheet was this ="" compared to <>0. What's the difference? Thanks.
Dilipandey is off-line right now. ="" tests for an empty cell (contains no data at all), while <> 0 tests for a value that is no = to 0 - the cell actually contains some data, even if it is zero, a cell with zero in it (ie 1-1) actually does have content in it
so it is now testing for blank/empty cells, rather than cells that may (or may not) contain zero
Hope that makes sense?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks FDibbins for replying.
Amartino, hope this solves your issue. ... if so, please mark this thread as [SOLVED]..
Regards,
DILIPandey
<click on below * if this helps>
Thanks. How do I mark the thread solved?
Go to the top of the thread >> Thread Tools >> Mark this thread as solved....
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks