HomeTek
New Member
- Joined
- Jan 27, 2017
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hi,
I have a spreadsheet in which I want to find out which sport has accumulated the most playing time (example below).
The answer is of course cricket, but I am having trouble with what formula I need to enter into cell J2 to provide this answer, if anyone can help at all please?
I have played around with sumifs etc but to no avail.
Thanks
I have a spreadsheet in which I want to find out which sport has accumulated the most playing time (example below).
The answer is of course cricket, but I am having trouble with what formula I need to enter into cell J2 to provide this answer, if anyone can help at all please?
I have played around with sumifs etc but to no avail.
![bWi8gu.jpg](/board/proxy.php?image=https%3A%2F%2Fi.snipboard.io%2FbWi8gu.jpg&hash=c6c569943e4cc8b2f7ae2fec51687437)
Thanks