Conditional expression problem
- From: "drdr32" <drdr32@xxxxxxxxxxx>
- Date: 21 Jun 2005 05:26:01 -0700
I have a work*** that has sign-in data for people working one of 5
shifts every day - I download information from a database and paste it
into the *** and it calculates hours worked for each shift, puts them
into columns for each person, and sums hours for different shifts that
are paid at different rates. Now I need to identify weekends, so I
added a column that uses the WEEKDAY function to resolve to true or
false for each shift.
Now I'm trying to modify the expression that sums the hours worked on a
particular shift called "RMP Day" which also happen to be weekends. In
the example shown, the column E has the shift name, H has the hours
data (to be summed), and V has the TRUE/FALSE for weekends. It doesn't
work - I get 0 whether I try to sum based on true or false. Any ideas?
Thanks!
GR
{=SUM(IF(AND($E$7:$E$207="RMP Day",$V$7:$V$207=FALSE),H$7:H$207))}
.
- Follow-Ups:
- Re: Conditional expression problem
- From: Bob Greenblatt
- Re: Conditional expression problem
- From: JE McGimpsey
- Re: Conditional expression problem
- From: J Laroche
- Re: Conditional expression problem
- Prev by Date: Disabling font smoothing
- Next by Date: Unable to Load Frameworks error
- Previous by thread: Disabling font smoothing
- Next by thread: Re: Conditional expression problem
- Index(es):
Loading