=F5-LOOKUP(1000,F5:AF5) help

[agoodson56]

I currently have a formula that takes what is in cell F5 as my starting weight then it subtracts or adds each weeks new weight across the sheet and totals my loss or gains in AH5. =F5-LOOKUP(1000,F5:AF5)

My problem is I don't want cells I5, K5, M5, O5, Q5, S5, U5, W5, Y5, AA5, AC5, AE5 included in the above formula.

 

[T. Valko]

I currently have a formula that takes what is in cell F5 as my starting weight then it subtracts or adds each weeks new weight across the sheet and totals my loss or gains in AH5. =F5-LOOKUP(1000,F5:AF5)

My problem is I don't want cells I5, K5, M5, O5, Q5, S5, U5, W5, Y5, AA5, AC5, AE5 included in the above formula.

OK, those excluded cells follow the pattern of every other cell. What about the first few cells? F5:H5?

Where does the data actually start?

 

[agoodson56]

I for got G5

F5 is the start cell
AH5 is the total loss cell

 

[T. Valko]

I for got G5

F5 is the start cell
AH5 is the total loss cell

Try this...

=F5-LOOKUP(1,1/((MOD(COLUMN(G5:AE5)-COLUMN(G5),2)=1)*G5:AE5),G5:AE5)

 

[agoodson56]

That worked great thank you!

 

[T. Valko]

That worked great thank you!

You're welcome. Thanks for the feedback!