Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Column with next column containing specific word
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Column with next column containing specific word
=SUMIF(M18:M31,"Floating Holiday - Bday",L18:L31)
or =SUMIF(M18:M31,"*Floating Holiday - Bday*",L18:L31) if the criteria is part of the cell(s) you can also replace the hardcoded text string with a cell and then put the criteria in the cell -- Regards, Peo Sjoblom "Sarah" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Column with next column containing specific word
=SUMIF(M18:M31,"Floating Holiday - Bday",L18:L31)
HTH, Paul "Sarah" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
find a specific value in a column and write another column | Excel Discussion (Misc queries) | |||
Finding specific word in column | Excel Worksheet Functions | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions |