| 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) | |||
Linear Mode
