Okay working on the sheet I have (I'm guessing you probably want this in one cell, which I will work on tomorrow. But for now this will get you through) In cell J 151 (On my sheet, assuming you want the total at the bottom of Column J?) use this
then in the cell under use this
Then for your total use
Sorry for the confusion I thought you wanted to sum the 72.48s and 50.59s. Could have given this to you ages ago. Thanks for friending me too, I accepted did you get that? Is this formula okay? You can move the COUNTIF & COUNTA to a different location and then put the = SUM in the Total column. Sorry it took so long, me being a dummy lol
Bookmarks