I am trying to make a spreadsheet which i thought would be a simple spreadsheet, maybe is but i cant get my head around something.
its a spreadsheet that counts the days i am home and away and also counts my wages.
work column is the days i am away calculated by each x
home is calculated by each space left blank
500 column is my day rate (just for illustration) but its basically a duplicate column that i dont want i just needed to put in a number at the top so for the next total column i had a number to multiply by to get an answer so in cell AJ3 i have =AI2*$AI$3
is there a way to have cell AG2 hold the value 500 but still say work so i can get rid of the extra row but still have something to multiply by?
or can i add to the formula in cell AG3 which i have =COUNTIF(B3:AF3,"x")
something like then times answer by 500? to get the answer in AJ3?
Thanks in advance for any help
its a spreadsheet that counts the days i am home and away and also counts my wages.
work column is the days i am away calculated by each x
home is calculated by each space left blank
500 column is my day rate (just for illustration) but its basically a duplicate column that i dont want i just needed to put in a number at the top so for the next total column i had a number to multiply by to get an answer so in cell AJ3 i have =AI2*$AI$3
is there a way to have cell AG2 hold the value 500 but still say work so i can get rid of the extra row but still have something to multiply by?
or can i add to the formula in cell AG3 which i have =COUNTIF(B3:AF3,"x")
something like then times answer by 500? to get the answer in AJ3?
Thanks in advance for any help
