I'm new to excel and I have been tasked to build an excel file to cover job status and billing. I can get most of the stuff working with basic formulas like Sumif and others along with basic VBA. Problem is I cant figure out formula to get total billed from sheet and then formula to show remaining after billed thru here. Basically how would I go about summing after a phrase for example. In the sheet it says "Billed Through Here" So anything after that depending on job would be summed separately. Hope fully I explaining right. I don't even know if its possible thought I would ask since most of what I learned came from the forums here. The Sheet is the JobInfo sheet.
Bookmarks