sum data depending on the month

**rana_shaker** · 12-01-2012, 07:27 AM

hi
column E is a date column with some blank cells too
I want to sum the values in column I only if the month in column E in the same row is august or before
and return the result to the cell "I7616"
I am new to this ... I tried this code but I don't know what is wrong with it
the editor highlights the if statment line ...

can you help me ??

Please Login or Register  to view this content.

**Palmetto** · 12-01-2012, 07:51 AM

Seems you should just use a formula for this

=SUMPRODUCT(--(MONTH(E1:E7614)<=8)*(E1:E7614<>"")*(I1:I7614))

**rana_shaker** · 12-01-2012, 08:18 AM

thanks for help but I want to return the value to textbox too and use it in other calculation on my program and the month august will be changed according to a combobox selection

... thats why am using vba

**Palmetto** · 12-01-2012, 08:33 AM

I don't get any errors when running your code, though I only tested it on a limited range of rows.
However, if the month is changing per a combobox selection, then you need to define a variable for this and replace the hard-coded "8" with the variable.

**AB33** · 12-01-2012, 08:33 AM

I think the error is most likely in this part of the If statement

Month(Cells(i, "E").Value) <= 8 Then.

My guess is you need to put the date in the right format

**rana_shaker** · 12-01-2012, 01:18 PM

thanks everybody ... it was useful and I solved the problem

**Palmetto** · 12-01-2012, 03:54 PM

Please tell the forum how you solved it so that others who face a similar issue will have an answer.

sum data depending on the month

LinkBack

Thread Tools

Rate This Thread

Display

sum data depending on the month

Re: sum data depending on the month

Re: sum data depending on the month

Re: sum data depending on the month

Re: sum data depending on the month

Re: sum data depending on the month

Re: sum data depending on the month

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions