How to count cell values based on 2 conditions

**ciw916** · 11-20-2012, 12:12 AM

Hello,

I have this attachment that shows terminated employee headcount for various call center locations. My goal is to summarize this data (not only by day, but by shift) on both the Center Summary and the Department Summary.

I've attempted to use the COUNTIFS function, however I receive a #VALUE because I'm attempting to combine both text and number criteria.

Can you think of a function that would allow me to total up the number of "1"s under each day, each shift?

Let me know if I can clarify this any further.

**vlady** · 11-20-2012, 01:50 AM

can you try this one if this is what you are after ->D4 (Center Summary)
fill down.
=COUNTIFS(Albuquerque!$C$3:$C$219,1,Albuquerque!$A$3:$A$219,">="&'Center Summary'!B4,Albuquerque!$B$3:$B$219,"<="&'Center Summary'!C4)

**ciw916** · 11-20-2012, 10:01 AM

Thanks for the reply! I think I see where you're going here. Although I'm getting some weird numbers.

Please take a look at the attachment. The results under Center Summary don't seem to match the ABQ numbers. Any idea why? I see that you added operators to the comparison condition. Am I missing something else?