Count If
 

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

Count If
 

=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

Count If
 

=IF(A1="X",COUNT(A1:A4),"")
--
Brevity is the soul of wit.


"Carter68" wrote:

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

Count If
 

A is not a row, it is a column.

Assuming you want to count A1:D1 in E1 enter this

=IF(A1="x",COUNTA(A1:D1),"A1 not x")

If you really mean A1:A4 then enter this in A5

=IF(A1="x",COUNTA(A1:A4),"A1 not x")


Gord Dibben MS Excel MVP


On Wed, 24 Jan 2007 10:51:03 -0800, Carter68
wrote:

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