G
Guest
Here is the situation:
I have a spreadsheet I am using for a timecard, in column Q, rows 18-31, I
have a spot for employees to type in their "other" hours. In Column R in the
same rows I have a spot for them to choose from a drop down what type of
hours they are (say Berevement, Floating Holiday...). What I would like to do
is be able to pull the sum of each type for the pay period.
How do I turn the following idea into a function:
If "Floating Holiday - Bday" shows in any cell in M18:M31 sum the total
hours in L18:L31.
Thank you!
I have a spreadsheet I am using for a timecard, in column Q, rows 18-31, I
have a spot for employees to type in their "other" hours. In Column R in the
same rows I have a spot for them to choose from a drop down what type of
hours they are (say Berevement, Floating Holiday...). What I would like to do
is be able to pull the sum of each type for the pay period.
How do I turn the following idea into a function:
If "Floating Holiday - Bday" shows in any cell in M18:M31 sum the total
hours in L18:L31.
Thank you!