How do you write the formula to sum the row if the cell contains a specific letter then sum the number beside it? I would sum each row independently. If I need to I can have the letters put before the numbers or put a space between them. I'm stuck on how to put the formula together. I can get it to total the numbers but it looks at all numbers regardless of the letter designation by using [ =SUM(IF(ISNUMBER(LEFT(B11:Z11,1)+0),LEFT(B11:Z11,1)+0)) ]. How do I get it to also look at the letter and only count the numbers next to the letters I designate?
If it helps, this is for tracking vacation, sick days and other HR related days missed. They want one calendar that contains all info. Names are in column A and days are column headers with a column at the end of the month that totals how many of each there are.
In the following example it would show that there the sum of the cells with S in them is 16.
Example:
If it helps, this is for tracking vacation, sick days and other HR related days missed. They want one calendar that contains all info. Names are in column A and days are column headers with a column at the end of the month that totals how many of each there are.
In the following example it would show that there the sum of the cells with S in them is 16.
Example:
4EU | 8S | 8F | 5F | 8V | 8S |