Sum ifs value for date=month

**Vandini.S** · 03-03-2015, 08:01 AM

Hi,

please find the attached file.

I want sumifs value of Feb month in sheet 2, in column C1(Sum of invoice value from sheet 1 in column C)

please help me.

**Fotis1991** · 03-03-2015, 08:22 AM

First you need to convert your "dates" in column B to real dates(use Text to Columns for that). Just now is Text that looks like date.

Then in B2 and copy down, use this.

Formula:

=SUMPRODUCT((Sheet1!$A$2:$A$100=$A2)*(MONTH(Sheet1!$B$2:$B$100)=MONTH($B$1))*(Sheet1!$C$2:$C$100))

**Vandini.S** · 03-03-2015, 09:14 AM

Thanks

I tried, but there is an error. Is there any other formula?

Thank again

**Fotis1991** · 03-03-2015, 09:49 AM

Originally Posted by Vandini.S

Thanks

I tried, but there is an error. Is there any other formula?

Thank again

You didn't try so much because as SDCh prooved, formula works fine. The point is to understand that you have to convert to real dates(numbers) the text that you have in column B of your first sheet.

**SDCh** · 03-03-2015, 09:26 AM

See the attachment

Note:
Credit belong to Fotis

Sum ifs value for date=month

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Sum ifs value for date=month

Re: Sum ifs value for date=month

Re: Sum ifs value for date=month

Re: Sum ifs value for date=month

Re: Sum ifs value for date=month

Thread Information

Users Browsing this Thread

Similar Threads

Sort month/date/year data using month and date only

How can i show date in this form (month,last date of that month, Year)?

[SOLVED] Date function- 1st day of month for 2nd full month from start date

Array function for date(month), Range Date(month)

[SOLVED] Date arithmetic: adding 1 month to prior end of month date

Bookmarks

Bookmarks

Posting Permissions