=IF(a1="x",COUNTA(a1:a4),"")

--
Don Guillett
SalesAid Software

"Carter68" wrote in message
...
I need to know how to count a row if it meets conditional criteria. If
Cell
A1 = "X" then count A1:A4

Here is an example of what the spreadsheet would look like.

DDA SAV Card MMA Total
X X X 3