Originally Posted by

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