Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing beginning minus sign from telephone numbers | Excel Discussion (Misc queries) | |||
Need formula to count spinoffs | Excel Worksheet Functions | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |