Hard to do a SUMIF for criterion "is not blank" so I used
=SUMPRODUCT(--(A1:A4>""),B1:B4)+SUMPRODUCT(--(A1:A4>""),C1:C4)
For info on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
>I have a problem in using an If Statement and adding statement
> together.
[quoted text clipped - 12 lines]
>
> Thanks for the help.
Khoalty@gmail.com - 08 Nov 2006 19:13 GMT
Thank you Bernard,
You are definitely the Excel Guru and saved me for masses of headaches.
> Hard to do a SUMIF for criterion "is not blank" so I used
> =SUMPRODUCT(--(A1:A4>""),B1:B4)+SUMPRODUCT(--(A1:A4>""),C1:C4)
[quoted text clipped - 23 lines]
> >
> > Thanks for the help.