LinkBack URL
About LinkBacks
Hi Folks
Have attached a Workbook to explain the formulas required.
Have used similar ones before but cannot get them to work here-
Cheers
hammer
Hi Folks
Have attached a Workbook to explain the formulas required.
Have used similar ones before but cannot get them to work here-
Cheers
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
Try
B2 =COUNTIF(Data!$J$2:$N$16,Workouts!$A2)
C2 =SUMPRODUCT(--(Data!$J$2:$N$16=Workouts!$A2)*(Data!$D$2:$D$16=1))
D2 =SUMPRODUCT(--(Data!$J$2:$N$16=Workouts!$A2)*(Data!$D$2:$D$16=1)*(Data!$E$2:$E$16))
E2 =SUMPRODUCT(--(Data!$J$2:$N$16=Workouts!$A2)*(Data!$P$2:$P$16))
Fantastic effort again Sir!
Thank you so much-
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks