SUMPRODUCTS with OR

[Laserek_Poland]

Dear

I have a question to you.
Im using SUMPRODUCT for some querry and its perfectli works if at criteria Im using onlu one paramiter for one comumn.

But now I want to use two parameters for one of columns.

Simple example below


Month Turnover …….
Jan 1
Feb 2
March 3
…
…
…
Dec 10

So how to make SUMPRODUCTS for column A (Month) and know sum of turnover in Jan and Dec ot Jan March and DEC?
Any suggestion?

Greg

 

[sandy666]

maybe =SUMPRODUCT((A2:A13="Jan")*B2:B13)+SUMPRODUCT((A2:A13="Dec")*B2:B13)+SUMPRODUCT((A2:A13="Mar")*B2:B13)
or
=SUMPRODUCT(--((A2:A13="Jan")+(A2:A13="Dec")+(A2:A13="Mar")),B2:B13)

 

[Dave Patton]

Excel 2010
	A	B	C	D
2	Jan	2		18
3	Jan	3
4	Feb	4
5	Feb	5
6	Dec	6
7	Dec	7
7a

Cell Formulas
Range	Formula
D2	=SUMPRODUCT(--((A2:A13="Jan")+(A2:A13="Dec")),(B2:B13))

You can use "+" for "Or".

 

[jtakw]

Hi,

You can do either of these, add as many conditions as you need within the curly brackets:

Book1
	A	B	C	D
1	Month	Turnover
2	Jan	1		16
3	Feb	2		16
4	Mar	3
5	Apr	4
6	May	5
7	Jun	6
8	Jul	7
9	Aug	8
10	Sep	9
11	Oct	10
12	Nov	11
13	Dec	12
Sheet162

Cell Formulas
Range	Formula
D2	=SUMPRODUCT((A2:A13={"Jan","Mar","Dec"})*B2:B13)
D3	=SUM(SUMIF(A2:A13,{"Jan","Mar","Dec"},B2:B13))