You’re offline. This is a read only version of the page.
45
This is my input file i want to do calculation for those 4users, and want to write final output into day wise total column according to Running, cycling and strength.
Is there any excel formula for this?
and also want to make this dynamic... now i have 4 users data but next time it will become 5 then want to calculate for those 5users
Expected Output:
Try the SUMIF formula
https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
https://www.extendoffice.com/documents/excel/2464-excel-sum-values-based-on-text.html#a1
In cell N3
=SUMIF($B$2:$M$2, "Running", $B3:$M3)
Share
Report
All responses (
Answers (
