Hi there, In the attached spreadsheet I need '$ Chart'!S2 to be the sum of '$ Tables'!D3:D73 but only for the rows where the value in column b is "c". I shouldn't be adding in any value where column b is U or N. This seems like it should be extremely easy, but it's fighting with me. I'd appreciate any help I can get.
Last edited by dropanddrive03; 03-09-2013 at 02:24 AM.
Use this, copied down...
=SUMIF('$ Tables'!$B$3:$B$73,'$ Chart'!R2,'$ Tables'!$D$3:$D$73)
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
I put that formula in Chart S2, no luck, output was 0
Actually there was just one small thing missing, I got it fixed from there. Thank you very much!!!!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks