spittingfire
01-19-2017, 04:32 PM
Hi all,
I have attached a sample sheet with some sample data.
Row B2:AW2 I have interval times in half hour intervals. Rows below B2 have the data. What controls the condition is cell AY1.
What I want is a formula in column AY from AY3 that will sum the row B:AW for each row. For example if AY1 = 18:30 then
Test1 = 162
Test2 = 769
Test3 = 1568
Test4 = 915
Test5 = 2916
Any help would be appreciated.
Thanks
I have attached a sample sheet with some sample data.
Row B2:AW2 I have interval times in half hour intervals. Rows below B2 have the data. What controls the condition is cell AY1.
What I want is a formula in column AY from AY3 that will sum the row B:AW for each row. For example if AY1 = 18:30 then
Test1 = 162
Test2 = 769
Test3 = 1568
Test4 = 915
Test5 = 2916
Any help would be appreciated.
Thanks