Hello All,
I'm trying to find the x in all ws then replace x by value in cell B at same row then sum total at each row. Please see sample in attached.
Regards,Please Login or Register to view this content.
tt3
Hello All,
I'm trying to find the x in all ws then replace x by value in cell B at same row then sum total at each row. Please see sample in attached.
Regards,Please Login or Register to view this content.
tt3
Easiest solution to get the totals at the bottom, just enter this formula in C22 and copy across:
=SUMPRODUCT((C2:C21="x")*$B$2:$B$21)
If the "x"s really have to go, then this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks