LinkBack URL
About LinkBacks
Assuming you have a current time in O2, try:
=SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1)),$C$2:$M$500)/SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1)))
you can copy formula down.
Is this what you need?
Assuming you have a current time in O2, try:
=SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1)),$C$2:$M$500)/SUMPRODUCT(--(MOD($A$2:$K$500,1)=MOD(O2,1)))
you can copy formula down.
Is this what you need?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks