Sum Problem

[OriginalStealth]

Column A Column B Column C
1 jan 04 10.00 60.00
5 jan 04 20.00
10 jan 04
15 jan 04
20 jan 04 30.00

How can I sum the values of column b only if there is a
date in column a.

 

[Bob Phillips]

I assumed only dates can be in A, so give a formula for where A is not empty

=SUMIF(A:A,"<>",B:B)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)