Searching Columns and Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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.
 
Back
Top