What row is the first formula being placed into?
How far down does it need to go (what is the last column it needs to reference)?
Hi All,
=COUNTIF(tab1!BA2:BA33726, "No")
needs to reference BA4 - to BA33726
ADVERTISEMENT
ADVERTISEMENT
It should work on the original conditions you have laid out. If you changed them, then the solution would obviously have to be changed too.Thanks but that doesn't quite work.
If you just want to return the value from those cells, then enter the following formula in C1 and copy down:What I have now done is update row BA33727, BB33727 onwards up to CN33727 with totals in tab1, however in tab2 C1 I want to return the value in BA, in C2 the BB value and so on, can this be done?
=OFFSET(tab1!$BA$33727,0,ROW()-1)
It should work on the original conditions you have laid out. If you changed them, then the solution would obviously have to be changed too.
If you just want to return the value from those cells, then enter the following formula in C1 and copy down:
Code:=OFFSET(tab1!$BA$33727,0,ROW()-1)