Sum formula with date and month

**wiewie002** · 12-14-2018, 08:22 AM

Dear Friends,
Need your help. I create monthly summary from date data, but result is 0.
I put details in atached file. please advise for formula.
Thank you in advance for your help.

Regards,
Wie

**63falcondude** · 12-14-2018, 08:30 AM

Try these:

B3 =SUMIFS('Summary Transaksi Harian'!$B:$B,'Summary Transaksi Harian'!$A:$A,">="&B2,'Summary Transaksi Harian'!$A:$A,"<="&EOMONTH(B2,0))

B4 =SUMIFS('Summary Transaksi Harian'!$C:$C,'Summary Transaksi Harian'!$A:$A,">="&B2,'Summary Transaksi Harian'!$A:$A,"<="&EOMONTH(B2,0))

**samba_ravi** · 12-14-2018, 08:30 AM

B3=SUMIFS(INDEX('Summary Transaksi Harian'!$B:$C,,MATCH($A3,'Summary Transaksi Harian'!$B$2:$D$2,0)),'Summary Transaksi Harian'!$A:$A,">"&EOMONTH(B$2,-1),'Summary Transaksi Harian'!$A:$A,"<="&EOMONTH(B$2,0))

Please Login or Register  to view this content.

Try this copy and paste across

**wiewie002** · 12-14-2018, 09:03 AM

Great help from both of you.
Thank you very much

**63falcondude** · 12-14-2018, 09:08 AM

You're welcome. Glad we could help.

Thanks for the rep!

**wiewie002** · 12-14-2018, 09:19 AM

Thank you very much

Sum formula with date and month

LinkBack

Thread Tools

Rate This Thread

Display

Sum formula with date and month

Re: Sum formula with date and month

Re: Sum formula with date and month

Re: Sum formula with date and month

Re: Sum formula with date and month

Re: Sum formula with date and month

Thread Information

Users Browsing this Thread

Similar Threads

Formula to give week number of a month according to date of the month

[SOLVED] Need Formula that will show 'Month" for date that fall in the particular month

Formula to change date american (month first) to uk style (month second)

[SOLVED] Formula to return End OF Month date with non-calendar month lengths.

Date Formula for days of the month, new dates starting on the 2nd of the month.

[SOLVED] Date formula with text in same cell but using previous month not current month

Formula to return day based on month end date & day number of month

Bookmarks

Bookmarks

Posting Permissions