I need help with the following problem: I was using the nested if function,
but due to limitation of seven levels only, i need to find alternative
solution to my problem.
I want to be able to use hlookup combined with the sum function to add up
noncontiguous numbers. Here's my formula to extract and sum data for June -
fringe:

z1=jun
=hlookup(z1,a1:g8,sum(2,6),false))
i want to add up fringe for month of june = 450
currently this formula yield = 0
2 3 4 5 6 7 8 9
1 jan feb mar apr may jun jul aug...dec
2Salary FT 500 550 600 500 550 600 500 550
3Hourly FT 400 450 500 400 450 500 400 450
4Fringe FT 300 350 400 300 350 400 300 350
5
6Salary PT 250 250 250 250 250 250 250 250
7Hourly PT 200 200 200 200 200 200 200 200
8Fringe PT 150 150 152 141 90 50 85 125