Is there a way to add another variable in this statement?
Column L is the value to add, Column A is where the data is that matches CV$2. I have another column that has "YES" and blanks so I only want to sum those items that say "YES". Is that possible?
=SUMPRODUCT(SUBTOTAL(9,OFFSET('Billings Data'!$L$2,ROW('Billings Data'!$L:$L)-ROW('Billings Data'!$L$2),0)),('Billings Data'!$A:$A=CV$2)+0)
The way I would probably handle this, would be to create a helper column to test for each of those criteria, and then pull in the value if they are all met - then sum that column. Helpers can be hidden if needed.
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