Solved! Big thanks to Fluff over at MrExcel.com
Posts by El Gallo


[xpost][/xpost]
mrexcel.com/board/threads/coun…tenateandsumif.1145524/
Hi Everyone,
I'd like to concatenate values from two columns if they match the criteria from another sheet. Here's what I've come up with so far but I just can't get it give me the correct values:
=IF(COUNTA(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$C$2:$C$250)=1),CONCATENATE(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$B$2:$B$250)&" "&(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$C$2:$C$250))),(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$B$2:$B$250)))
The data I want is a score and if it was late. If it wasn't late, all I want is the score.
I've attached a dummy worksheet in the hopes that it helps to explain what I'm after.

Re: Button to add contents of A1 to B1, then return A1 to zero
That is helpful. Thank you so much.

Re: Button to add contents of A1 to B1, then return A1 to zero
Thanks Alan, but for whatever reason I had to delete the <AddandZero()> to make it work. Otherwise nothing happened. Also, I realized that I don't actually want A1 to return to zero but to return to the formula that was actually in A1, ie =SUM(A2). Is this possible?
Thanks.

I have created a button that will increase A1 by one each time it's clicked. I'd like another button that will add whatever total that is in A1 to B1, then return A1 to zero. I am just discovering vb...
Thanks for your time.