Sumproduct
 

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


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=517431

Sumproduct
 

ceemo Wrote:
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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517431

Sumproduct
 

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


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=517431

Sumproduct
 

Try...

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

Hope this helps!

In article ,
ceemo wrote:

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