markbednarski
New Member
- Joined
- May 19, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
We have a spreadsheet for 7 months of the year. Each month has the day number in each column and in each month there are three names - Mark, Ola and Atul in rows. We want to sum the total number of days taken off each month marked as "off" in each cell corresponding to the month, day and name. Hence we want to create a formula to look at each row and say it says Mark, we want to use this condition to sum up the numbers of days marked off for that row and then for all other rows. There will be 7 instances of Mark in rows, and say 3 day off in May, another two in June and them four in August. I'm think if a conditional formula that will countif the instances of "off" based on the row in the array that has the specific name. Cannot figure out how to do this. Please help.