# SImple SUMIF

#### mas_lerdanch

##### Board Regular
Hey
My third post in this excellent forum! :->

I want to sum my column 11 (Named Profit2007) when column 1 (Named Date2007) is equal to any given month eg June or 06.

The date range in Date2007 runs from 01/10/2006.

Date2007 is formatted 01/01/2007.

Is there also a formula to give cumulative results week by week starting on that date?

All the best Mas Lerdanch

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### dave3009

##### Well-known Member
Hi Mas

Try SUMPRODUCT

=SUMPRODUCT(--(MONTH(\$A\$2:\$A\$600)=6), \$K\$2:\$K\$600)

Hope it helps

KR

Dave

#### mas_lerdanch

##### Board Regular
Thanks Dave that works well and I can adapt it to suit.

My booking year starts in September and ends in September how do I specify a year and month instead of just a month?

best wishes

Mas

##### MrExcel MVP
Hey
My third post in this excellent forum! :->

I want to sum my column 11 (Named Profit2007) when column 1 (Named Date2007) is equal to any given month eg June or 06.

The date range in Date2007 runs from 01/10/2006.

Date2007 is formatted 01/01/2007.

Is there also a formula to give cumulative results week by week starting on that date?

All the best Mas Lerdanch

X2 houses a relevant from date, Y2 a relevant to date, with Y2 >= X2...

=SUMIF(Date2007,">="&X2,Profit2007)-SUMIF(Date2007,">"&Y2,Profit2007)

#### Stormseed

##### Banned
Thanks Dave that works well and I can adapt it to suit.

My booking year starts in September and ends in September how do I specify a year and month instead of just a month?

best wishes

Mas

Here you go...
Book1
ABCD
1DateFormulaValues
23/3/20073010
36/3/200520
46/9/200630
5
Sheet1

#### mas_lerdanch

##### Board Regular
Thanks Aladin and Stormseed! will crack on! All the best - Mas

#### mas_lerdanch

##### Board Regular

From your formula for a specific week I am getting a return of 0.

I have tried adapting but to no avail ... am i being silly...
example.xls
ABCDEFG
1
310/10/20050.001,460.001,460.00(SUMIF(Datex,">="&1/1/2007,Turnx))-(SUMIF(Datex,">"&8/1/2007,Turnx))
412/10/20050.00675.00675.000
512/10/20050.001,540.001,540.00
612/10/20050.00990.00990.00
712/10/20050.00710.00710.00
813/10/20050.00930.00930.00
914/10/20050.00432.00432.00
1014/10/20050.001,340.001,340.00
1114/10/20050.001,702.861,702.86
1217/10/20050.00780.00780.00
1318/10/20050.003,500.003,500.00
1418/10/20050.00385.71385.71
1519/10/20050.002,142.862,142.86
1619/10/20050.00375.00375.00
1720/10/20050.00664.29664.29
1820/10/20050.00550.00550.00
1922/10/20050.00770.00770.00
2022/10/20050.00758.57758.57
Sheet1

#### mas_lerdanch

##### Board Regular
The amp; is not in the formula or gt is not in the formula
the formula i am using is as follows - sorry first time using Colo's Html Generator...

Formula
=(SUMIF(Datex,">="&13/10/2005,Turnx))-(SUMIF(Datex,">"&20/10/2005,Turnx))

#### mas_lerdanch

##### Board Regular
Woo hoo - a little tweaking got me a result - i can't see why the other wasn't working though...

=SUMIF(Datex,"<="&DATE(2005,10,20),Turnx)-SUMIF(Datex,"<"&DATE(2005,10,13),Turnx)

Replies
12
Views
484
Replies
2
Views
405
Replies
2
Views
493
Replies
0
Views
332
Replies
5
Views
6K

1,191,421
Messages
5,986,483
Members
440,031
Latest member
davidvillegasr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back