Help on and IF comparsion

[JustMe602]

I want to get a sum of 3rd column when the 4th column has data but the
5th column doesn't. Then I want a count of the 3rd column when both the
4th & 5th column has data.



92167.118 REC 3 Feb 02, 2006 Feb 13, 2006
92197.050 REC 2 Jan 23, 2006
92197.050 REC 2 Jan 23, 2006
92203.001 REC 2 Mar 23, 2006 Mar 30, 2006
92203.001 REC 2 Mar 23, 2006 Mar 30, 2006
92242.001 REC 4 Jan 23, 2006 Apr 06, 2006
92242.001 REC 4 Jan 23, 2006 Apr 06, 2006
93354.002 REC 1 Jan 03, 2006
95365.003 REC 1 Jan 23, 2006
95365.005 REC 1 Jan 01, 1900
96271.001 REC 3 Apr 04, 2006
96271.001 REC 3 Apr 04, 2006
96271.001 REC 3 Apr 04, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006
97191.001 REC 8 Feb 02, 2006 Apr 06, 2006

sum(if).... sum(if)...

 

[Bob Phillips]

=SUMPRODUCT(--(D120<>""),--(E1:E20=""),C1:C20)

=SUMPRODUCT(--(D120<>""),--(E1:E20<>""),C1:C20)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)