Hi everyone,
I have been trying to find the following info on the net and its driving me insane!
There must be a simple explanation to this, so any help would be greatly appreciated.
A1=1
A2=2
A3=3
A4=4
I need help with:
=COUNTIF(sheet1!A1:sheet1!A4,"<2")
Answer = 1
My probelm is that if i want to continually manually keep add data to rows A5, A6, A7, A8 with various numeric values.
How can i have the A4 (Highlighted in red in the formula above) update automatically with the newest latest row reference number, for example, A5=3,A6=7,A7=11,A8=34 etc.. is this possible?
I guesss i would describe this as an formula auto update
Have i made myself clear? What are your thoughts please?
Cheers
Paul
Bookmarks