Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching Columns and Rows
I am trying to find a function to count the occurrences of a specific number
in a range of cells in 2 adjacent rows and 45 adjacent columns. Also, how would the formula change if the rows and columns were not adjacent? Any sugestions would help. -- Cliff |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching Columns and Rows
Have you tried COUNTIF(range,criterion) ?
Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching Columns and Rows
one way
=COUNTIF(A10:G11,"=45")+COUNTIF(I10:L11,"=45") or =COUNTIF(A10:G11,45)+COUNTIF(I10:L11,45) change the ranges to suit and you could store the number 45 in a cell........... A2 =COUNTIF(A10:G11,A2)+COUNTIF(I10:L11,A2) -- Greetings from New Zealand Bill K "Cliff" wrote in message ... I am trying to find a function to count the occurrences of a specific number in a range of cells in 2 adjacent rows and 45 adjacent columns. Also, how would the formula change if the rows and columns were not adjacent? Any sugestions would help. -- Cliff |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching Columns and Rows
Thanks, I got the formulas to work when referencing a range of cells with
numbers directly entered, but they would not work with a range of cells that had other formulas totaling a number in them. -- Cliff "Bill Kuunders" wrote: one way =COUNTIF(A10:G11,"=45")+COUNTIF(I10:L11,"=45") or =COUNTIF(A10:G11,45)+COUNTIF(I10:L11,45) change the ranges to suit and you could store the number 45 in a cell........... A2 =COUNTIF(A10:G11,A2)+COUNTIF(I10:L11,A2) -- Greetings from New Zealand Bill K "Cliff" wrote in message ... I am trying to find a function to count the occurrences of a specific number in a range of cells in 2 adjacent rows and 45 adjacent columns. Also, how would the formula change if the rows and columns were not adjacent? Any sugestions would help. -- Cliff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
searching columns and rows | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |