Sumproduct

[ceemo]

Hi, I would like to the number of rows where the following condition is
met

(ColA="V" or "D") and (Col=3 or Col=P). The answer would be 3 (rows
5,8,10)


i would also like to know how to sum ColE which would be 695


Please help,

Row ColA ColB ColC ColD ColE
1 A C 3 P 541
2 A C 4 O 2
3 V A 2 O 2
4 D A 1 P 54
5 F D 3 J 565
6 D A 4 U 95
7 F C 2 N 36
8 F D 3 J 45
9 J A 6 O 74
10 V D 8 P 85
11 E A 7 U 25
12 T A 8 M 32

 

[davesexcel]

Hi, I would like to the number of rows where the following condition is
met

(ColA="V" or "D") and (Col=3 or Col=P). The answer would be 3 (rows
5,8,10)


i would also like to know how to sum ColE which would be 695


Please help,

Row ColA ColB ColC ColD ColE
1 A C 3 P 541
2 A C 4 O 2
3 V A 2 O 2
4 D A 1 P 54
5 F D 3 J 565
6 D A 4 U 95
7 F C 2 N 36
8 F D 3 J 45
9 J A 6 O 74
10 V D 8 P 85
11 E A 7 U 25
12 T A 8 M 32

=sum(E1:E13) I get 1556

I think you have your columns mixed up, column 10 is not 3

 

[ceemo]

Yep i messed up the formula, which ive now corrected and also tyd'd up
the columns

(ColA="V" or colB"D") and (ColC=3 or ColD=P). The answer would be 3
(rows 5,8,10)


i would also like to know how to sum ColE which would be 695


Please help,

Row ColA ColB ColC ColD ColE
1 A C 3 P 541
2 A C 4 O 2
3 V A 2 O 2
4 D A 1 P 54
5 F D 3 J 565
6 D A 4 U 95
7 F C 2 N 36
8 F D 3 J 45
9 J A 6 O 74
10 V D 8 P 85
11 E A 7 U 25
12 T A 8 M 32
Edit/Delete Message

 

[Domenic]

Try...

=SUMPRODUCT(--((A1:A12="V")+(B1:B12="D")>0),--((C1:C12=3)+(D112="P")>0)
,E1:E12)

Hope this helps!