Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I looked at the postings for Sum if and Sum product, but can't get it to do
what I need. I want to count the total hours for Pam if she is listed for a shift (G9:M16). The hours of the shift are in F9:F16 (see below) I've tried =SUMPRODUCT((G9:M16="Pam"),F9:F16) & received a value error. =SUMIF(G9:M17,"Pam",F9:F16) only results in 7.5, counting her first occurence. F SHIFTS 7:00 AM 2:30 PM 7.5 Pam Alpha 7:15 AM 2:45 PM 7.5 Pam Gloria 8:00 AM 4:00 PM 8 Pam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Group Repeating Text Values in a Column? | Excel Discussion (Misc queries) | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |