I have Vlookup formulas inputted in an Excel Grid waiting to pull over data from another sheet. I have added sum total formulas as well, but they won’t calculate with the vlookup formulas sitting there. Is there a way to get the sum formulas to work only on cells with actual values pulling over?
What are you getting in the cells without values? #N/A, or some such error message? If so, you can wrap your current formula in an IFERROR formula, where you can specify what should be shown/returned in cells that evaluate to an error. Syntax is =IFERROR(your formula here,value if error) - I suggest a "0" if error, so that your sum formula will still work.
Hope this helps.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
@ shootingstarz - I would suggest that you add iferror to you're vlookups so they return a 0. that way, you're sum() functions will work just fine.
If you dont want a bunch of 0's, use iferror with "", then use sumif() or sumifS() constructed to exclude ""
=SUMIF(A1:A6,"<>"&"",C1:C6)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks