PDA

View Full Version : formula not working at column E of NE sheet



arnab0711
08-20-2012, 02:24 AM
Hi,
I have this array formula at column E of "NE" sheet,Which should give a result after certain criteria are meet,but I am getting '0' as a result,please advice.

Bob Phillips
08-20-2012, 03:43 AM
You only have data for Jan and Feb-2012, so you can only get 0.

arnab0711
08-21-2012, 04:52 AM
If you look into NEsheet,its the same problem.

Bob Phillips
08-21-2012, 08:37 AM
I don't understand the point that you are making, but I would check all your formulae if I were you, they don't seem to shift columns correctly.