Formula to Sum Specific Amounts
Putting it mildly, I don't understand formulas. I'd like a formula that will total all amounts when the word "Billed" is in the same row. Then another formula for when the word "Originated" is in the same row.
For example, every time I add a new month's totals, I'd like the YTD totals to update. I tried this, but I really don't know what I'm doing: =SUMIF(Month B & O:Month B & O; Billed:Billed) It's #UNPARSEABLE.
I'm attaching a screen shot. Please let me know if this needs more explaining. Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!