countif with some conditions
On Wednesday, September 4, 2013 9:02:25 PM UTC-7, BenEastCoast wrote:
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
Thanks in advance for any help ☺
+-------------------------------------------------------------------+
|Filename: countif.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=910|
+-------------------------------------------------------------------+
--
BenEastCoast
Give these a try.
"am" that is permanent =SUMPRODUCT(--($A$2:$A$10="PER")*($B$2:$B10="AM"))
"am" that is temporary =SUMPRODUCT(--($A$2:$A$10="TEM")*($B$2:$B10="AM"))
"pm" that is permanent =SUMPRODUCT(--($A$2:$A$10="PER")*($B$2:$B10="PM"))
"pm" that is temporary =SUMPRODUCT(--($A$2:$A$10="TEM")*($B$2:$B10="PM"))
Regards,
Howard
|