Hello all,

Basically,

I want to add a range of numbers in column AB

Cell range in AB

Year 1 = 04 to 364
Year 2 = 365 to 1035
Year 3 = 1036 to 1662
Year 4 = 1663 to 2500

if

'unemployed' is in column AD

and

'500' is in AX:BI

any ideas?

once again, much appreciated