I did have this working but I want to know how

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G Nisbet - 21 Jun 2007 15:59 GMT

I have a simple spreadsheet with 4 columns the first 2 columns have user
entered values.

Column 3 & 4 have "=A4*B4" & =SUM($C$4:C4)/SUM($A$4:A4) respectivly and this
works fine.

What I want is Excell to automatically add thes formula when I enter values
into row's 1 & 2. I know I could autofill the formula all the way down but I
want excell to do it as I go. As I said I did get it working but I don't know
how.

Reply to this Message

S.Y.M. Wong-A-Ton - 22 Jun 2007 08:22 GMT

Try reposting your question in the Excel newsgroup:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.excel.work
sheet.functions&lang=en&cr=US
---
S.Y.M. Wong-A-Ton

> I have a simple spreadsheet with 4 columns the first 2 columns have user
> entered values.
[quoted text clipped - 6 lines]
> want excell to do it as I go. As I said I did get it working but I don't know
> how.

Reply to this Message