Sumproduct: outcome differs from same entry

[onbekend]

Hello,

I am using sumproducts for the first time and dont know what i do wrong..

I have one field with months and when i am using the following entry:

=SUMPRODUCT(--(month=B11);--(region=$B$2))

This formula works well for the months january and february, but not for the month march.

I dont understand, cause actually the only thing i change is "(month=B11)" in to "(month=B12)"

But the outcome in field is "0", which should be "4".

Any help would be appreciated!

 

[Aladin Akyurek]

Hello,

I am using sumproducts for the first time and dont know what i do wrong..

I have one field with months and when i am using the following entry:

=SUMPRODUCT(--(month=B11);--(region=$B$2))

This formula works well for the months january and february, but not for the month march.

I dont understand, cause actually the only thing i change is "(month=B11)" in to "(month=B12)"

But the outcome in field is "0", which should be "4".

Any help would be appreciated!

Care to post what you have in B11 and B12, and also a match cells from the month range?

 

[onbekend]

Mrexcel, could you please be a little bit more specific in your answer?
I dont understand what im supposed to do.

 

[Aladin Akyurek]

Mrexcel, could you please be a little bit more specific in your answer?
I dont understand what im supposed to do.

There was a typo there...

What I'm asking is (I'm not MrExcel) whether you would want to post the values from B11 and B12 along with some of the march cells from the month range?

 

[scottylad2]

Excel Workbook
	A	B	C
1	May	east	east
2	Feb	west	4
3	Sep	east
4	Sep	south
5	Dec	south
6	Jun	west
7	Oct	south
8	Nov	east
9	Aug	north
10	Dec	north
11	Oct	north
12	Nov	east
Sheet3

is your setup similar to this? C1 = jan

 

[scottylad2]

Excel Workbook
	A	B	C
1	Mar	east	west
2	Mar	west	2
3	Mar	east
4	Mar	south
5	Mar	south
6	Mar	west
7	Oct	south
8	Nov	east
9	Aug	north
10	Dec	north
11	Feb	north
12	Nov	east
Sheet3

this one will work, the last one shouldn't have

 

[onbekend]

There was a typo there...

What I'm asking is (I'm not MrExcel) whether you would want to post the values from B11 and B12 along with some of the march cells from the month range?

Excuse me for the misunderstanding, Aladin.

What i have is the following:

Jan: "=SUMPRODUCT(--(month=$B10);--(region=$B$2))" | outcome is 3
Feb: "=SUMPRODUCT(--(month=$B11);--(region=$B$2))" | outcome is 3
march:"=SUMPRODUCT(--(month=$B12);--(region=$B$2))" | outcome is 0, but should be 3.

What we try to do here is, that we want a total of the sales by month and region.

 

[scottylad2]

#Jan: "=SUMPRODUCT(--(month=$B10);--(region=$B$2))" | outcome is 3
#Feb: "=SUMPRODUCT(--(month=$B11);--(region=$B$2))" | outcome is 3
#march:"=SUMPRODUCT(--(month=$B12);--(region=$B$2))" | outcome is 0, but should be 3.

What we try to do here is, that we want a total of the sales by month and region.

Could you clarify, is month a named range you're referring to? the months I've marked, are they dates formatted to show the word month or is it text values and the words typed directly into the cells?

 

[onbekend]

Excel Workbook
	A	B	C
1	Mar	east	west
2	Mar	west	2
3	Mar	east
4	Mar	south
5	Mar	south
6	Mar	west
7	Oct	south
8	Nov	east
9	Aug	north
10	Dec	north
11	Feb	north
12	Nov	east
Sheet3

this one will work, the last one shouldn't have

Here comes the thing.. i copied my entry excactly from the practice sheet from school ( with answers) I actually dont want to use different entry's, then given in my practice sheet.

 

[Aladin Akyurek]

Excuse me for the misunderstanding, Aladin.

What i have is the following:

Jan: "=SUMPRODUCT(--(month=$B10);--(region=$B$2))" | outcome is 3
Feb: "=SUMPRODUCT(--(month=$B11);--(region=$B$2))" | outcome is 3
march:"=SUMPRODUCT(--(month=$B12);--(region=$B$2))" | outcome is 0, but should be 3.

What we try to do here is, that we want a total of the sales by month and region.

Ik wil de inhoud zien van B11 en B12. Laat ook de inhoud zien van een paar cellen die met de maand maart te maken hebben uit het bereik "month".