sumproduct problem?
There are probably blanks or something else Jim to indicate attendance.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jim May" wrote in message
news:cwNqg.51856$fG3.29160@dukeread09...
Since it doesn't seem to matter whether you are sick, bh or leave,
Just use SumIf using area1 as criteria.
=SUMIF(E5:E16,"area1",D5:D16)
"Bob Phillips" wrote in message
:
=SUMPRODUCT(--(ISNUMBER(MATCH($C$5:$C$16,{"sick","bh","leave"})) ),--($E$5:$E
$16="area1"),($D$5:$D$16))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Tolga" wrote in message
...
i'm using the sumproduct formula to pick up sick days for people
within an
area which works fine for one criteria.
=SUMPRODUCT(--($C$5:$C$16="sick"),--($E$5:$E$16="area1"),($D$5:$D$16))
I need the formula to pick up sick, bank holidays and annual leave
days
and
add them all together for each area. is this possible?
Thanks
Tolga
|