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