Hi all,
I am trying to use a worksheets function.sumifs as follows, however it is always returning 0. When I do the formula for the sumifs on the sheet itself this is not the case, does anyone have any idea why?
The sumifs is referencing itself i.e J is the same as transdata(i,10) - i know this works in a formula but perhaps not the case in a vba?
Please Login or Register to view this content.
Thank you
Can you post a workbook? Are you sure that TransDataCalcs(i, 3) has the value you expect?
Don
Please remember to mark your thread 'Solved' when appropriate.
A few questions...
1. Why not just use the SUMIFS function, instead of VBA?
2. Are you sure the values you are summing, really ARE values and not text looking like values?
3. Are you sure that your criteria really does exist in the criteria range? If you think it does, check for spellings, extra spaces etc
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