hey guys new to the site and i have a quick question. If i want to add from cells j10:j50 but only the specific cells that in d10:d50 contain the word banana how do i do it. if its not clear ill try to explain it a bit more. i hope someone can help.
thanks.
Try this:
Please Login or Register to view this content.
Last edited by ConneXionLost; 04-24-2013 at 01:56 PM.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Try
=SUMIF(D10:D50,"banana",J10:J50)
i think i explain wrong let me try this in anything with the value of c244 in d185:d204 sum up those same rows in j185:j204
i think this is more clear
Then:
Please Login or Register to view this content.
Hello,
In that case, try this formula
Edit: ConneXion, you beat me to it ...Please Login or Register to view this content.
(copy pasta from Ford)
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
Regards,
Lem
wow it worked that was an easy one i guess lol thanks alot im sure ill have alot more questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks