# Add up the total amount of cash depending on the month?

1. ## Add up the total amount of cash depending on the month?

Hi everyone,

Is there a way of adding up the total amount of cash depending on the month? For example, I want to know the total amount of cash gained for September, is there a formula that can automatically check which month im looking for and add up all the cash for that month?

I've attached a sheet which hopefully makes it clearer

Thank you for any help

King regards

2. ## Re: Add up the total amount of cash depending on the month?

With a slight amendment to the cells containing months, to make them dates, you could use SUMIFS to do this.

See attached.

BSB

3. ## Re: Add up the total amount of cash depending on the month?

Hi,

Make sure the dates in E1:P1 are proper date numbers then use a SUMIFS formula in E2 copied across.

i.e.

Formula:
`Please Login or Register  to view this content.`

See attached

4. ## Re: Add up the total amount of cash depending on the month?

Thank you very much BSB and Richard! Very kind of you both. could I ask a big favour? im not great with excel formula so I was just wondering if you could breifley explain what some of the formula bits mean?

=SUMIFS(\$B:\$B,\$A:\$A,">="&E1,\$A:\$A,"<="&EOMONTH(E1,0))

I understand 3/4 of it but im not sure what "&EOMONTH(E1,0))" is?

Thanks again for all your help

5. ## Re: Add up the total amount of cash depending on the month?

EOMONTH is "End Of Month"

It takes the date from a specified cell (in this case E1) and tells you what the last day of the month is the number of months onward specified by the last argument. In this case 0 months.
I use it to make 28/29/30/31 days in a month less hassle.

So EOMONTH(E1,0) is saying what's the last day of the month of the date in E1, zero months on. As E1 holds Sept-15, the result would be 30th Sept 2015.
EOMONTH(E1,1) would give you the result 31st Oct 2015.

So the whole formula says, sum the values in column B where column A holds values greater than or equal to 1st Sept 2015 and less than or equal to 30th Sept 2015.

Hope that makes sense....

BSB

6. ## Re: Add up the total amount of cash depending on the month?

Hi try this

``Please Login or Register  to view this content.``

7. ## Re: Add up the total amount of cash depending on the month?

Ah okay that makes more sense now.

Thanks for your help BSB ive added reputation and marked this thread as solved

Kind regards
Matt

8. ## Re: Add up the total amount of cash depending on the month?

Happy to help. Thanks for the rep point

BSB

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1