Concatenate & SUMIF Formatting

[MyLisaRachel]

Using Excel 2013 on Windows 8 laptop... not sure what else you need.

I've managed (I don't know how) to create this really cool formula in my file I use for my checkbook register to tell me the total balance that's cleared... but the formatting is wrong - and it's irritating me greatly! Any help or pointing to a post that already has the answer would be greatly appreciated! I've copied / pasted the formula below...

=CONCATENATE("Cleared Balance : "&SUMIF(MyTransactions[C],"=1",(((MyTransactions[Balance])))))

I really just want the "MyTransactions[Balance]" to display as $ ##.## but I can't figure it out! I've got it done on my current balance formula, but for some reason I cant figure out this one... it is past my bed time so my brain may just be fogged over! I've pasted below the formula for my current balance that IS formatting correctly. I don't know if the SUMIF formula is preventing the formatting, if I'm getting confused with all the dang parenthesis or what.

=CONCATENATE("Current Balance : "&TEXT(MyTransactions[[#Totals],[Balance]],"$#,##0.00"))

Thanks in advance for any assistance!!

MyLisa

 

[MyLisaRachel]

Ok, now that I test it more the formula isn't working anyways so nevermind... Not sure how to delete this.