countif with some conditions
Hi Ben,
Am Thu, 5 Sep 2013 05:02:25 +0100 schrieb BenEastCoast:
I have 2 WS (pls see attached), The first 1 I update regularly the
second 1 is my monthly summary.
I use countif in WeeklySummary, how do I count the:
"am" that is permanent
"am" that is temporary
"pm" that is permanent
"pm" that is temporary
in B2 of Book2:
=SUMPRODUCT(--([Book1]Sheet1!$A$2:$A$100=$A2),--([Book1]Sheet1!$B$2:$B$100=B$1))
and copy to the right and down.
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|