sThanks big help...how would I get 2 different criteria to add?

Ex If A1=z and B2 =y then count

but if A1=z and B2=z then dont count

Only count when the both criteria is met.

"JE McGimpsey" wrote:

One way:

A3: =COUNTIF(A1:A2,"z")

In article ,
"BRUISER1" wrote:

How do I get excel to count and sum cells that contain word variables?

Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of
cellls that equal "z"