How to calculate sales total for a month from the dates (more than 5 years data)

**devawad** · 08-27-2012, 07:57 AM

Dear All,

Kindly tell me HOW TO CALCULATE SALES TOTAL FOR A MONTH FROM THE DATES (MORE THAN 5 YEARS DATA)

I attached sample sheet for reference...please see and help

thanks in advance...

devawad

**Pepe Le Mokko** · 08-27-2012, 08:03 AM

You can try a Pivot Table

**devawad** · 08-28-2012, 01:31 AM

Dear, Pepe Le Mokko

Thanks and I appreciate your quick response,but I was looking for a formula for the same ...anyway thanks a lot.

Thanks and regards,

devawad

---------- Post added at 11:01 AM ---------- Previous post was at 10:54 AM ----------

Dear Fotis1991,

Thanks, You always gives best solutions for my problems/query's in a simple way,You are simply great......

Thanks...Thanks...Thanks...Thanks...Thanks...

That's all I can say..

regards,

devawad.

**Fotis1991** · 08-27-2012, 08:05 AM

Try

=SUMPRODUCT((YEAR(A2:A10)=YEAR(D1))*(MONTH(A2:A10)=MONTH(D1))*(B2:B10))

**BarryTSL** · 08-27-2012, 08:12 AM

Try

=ROUND(SUMIFS(B2:B10,A2:A10,">="&D1,A2:A10,"<="&EOMONTH(D1,0)),0)

How to calculate sales total for a month from the dates (more than 5 years data)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to calculate sales total for a month from the dates (more than 5 years data)

Re: How to calculate sales total for a month from the dates (more than 5 years data)

Re: How to calculate sales total for a month from the dates (more than 5 years data)

Re: How to calculate sales total for a month from the dates (more than 5 years data)

Re: How to calculate sales total for a month from the dates (more than 5 years data)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions