Cash Statement- Accruing balances

C

cjarrar

we are attempting to create a Cash Statement report for a single account and
would like to include a To Date, Month To Date and Fiscal Year totals. Is
there a formula out there that can accomplish this? We will be manually
inputting the "To Date" amount in its dedicated field.

Today This month to date Fiscal year to date


$6,956.20 $- $-
 
F

Fred Smith

You probably want Sumif, as in:
=sumif(a:a,">="&date(year(today()),month(today()),1),b:b)

The other formula would be similar, but a different starting date.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Total, Opening & Closing Acct Balance in Cash Book 1
SUMIF with multiple variables HELP!!!! 2
Need Function for Year-to-Date spent total 3
Help with Nested IF Then statement? 3
Need help displaying odd numbered month 3
First Half / Second Half Month Budget 3
How do I sum cashflows within date range given dates and cash flow 1
Partial Year Adjustments (Mod Function) 1

Top