Hi
I have 7 columns for days of the week (F through to L). there are three other columns:
B = %
C = %
D = $
There are five rows of importance here 4 - 8 with different $ amounts
I want to put a number in say, F4 (F = Monday; 4 = $155) and then multiply that by D and then find the % of that from C and then the % of that from B.
And then...
I want to do the same for other amounts from F G H I J K L...so that there are likely to be different amounts in, for example, F4, F5 G4, G7, H8 and so on.
I then want to SUM each column F through to L in row 10 (estimated income).
Sorry if this is confusing...I'm new to excel! I've attached a workbook to follow as to the above...the formula I worked out seems to work for two days, H and I but not for the other days #Value! error... and I'm sure there must be a more eloquent formula anyway...