I have a column of numerical data, for which I need frequency counts within
certain ranges.  E.G. If a cell value is >= 41 AND <= 50, I want to count
that cell as one.  I can't figure out the syntax.

I've created several workbooks for a project I'm leading. I've locked some
cells containing formulas, and protected the sheet, specifying that inserting
and deleting rows should be allowed. Unfortunately, I receive an error
message telling me that I'm trying to delete a row that ...

How do I change the row reference numbers on the left of the worksheet so
that the first row #1 is blank and then the row numbers start on row 2 but
with #1?

Isn't there a way to change a spreadsheet so the column headers change to
rows and the row headers change to columns?
I have Excel 2003.
Thanks, Meenie

I am trying to create a database of potential volunteers, including each date
we have made contact with them. There are a lot that have not replied to
emails for whatever reason so I want to follow-up with them. I just need to
know when to contact them again. There's got to be a ...

I have a column of text with 367 entries, author's names.  I have used
SUMPRODUCT to determine that there are 267 unique entries.  Is there a
formula I can now use to give me the author's name that appears most
frequently?  Thanks for your help.

I'm trying to use IF with other variable but is not working.
What I have:
Colum G12 - NET Sallary
Colum I12 - 3 possibilities (MRM, ME, AB)

Good afternoon,
I have this long formula made of "If's" and got an error for too many
nesting. I have tried to find in library similar problems and could not
exactly find same issue. Could somebody help?

I wish to add cells to alternating rows to move the info over to the next
column.
Is it possible to do that without highlighting each row?

i have a new purchase order and have most of it working now.  i have one
known issue left.  in order to follow along, you'll need three sheets/tabs
(minimum,) name them: TAB1, TAB2, TAB3
TAB2 has a list of suppliers (Column A will have the supplier's full name.  

OK - I admit it... I suck at SUMPRODUCT formulas!
Here is what I have now:
SUMMARY WORKSHEET:
 A4:A9 = SiteName

I have a question that seems to be the reverse of the others i'm seeing
here.  I don't want to do conditional formatting.  I have an exported Excel
table that already has colors assigned to different cells.  I want to create
an IF statement that says:  =IF(A1 is Red), then return ...

Looking  for a macro to hide any columns from columns "W" through "HE"
if the cell in that column in row 4 is equal to zero (a formula exists
in the row 4 cell.)
Also, I surmise, if the macro includes the word "true", I can change

Could someone please tell me why this formula is unacceptable?
=VLOOKUP(A1,{5,(A1+1);10,(A1+2);20,(A1+3)},2)
Regards - Dave.

I'm using a {=SUM(IF((A2:A11="1188")*(B2:B11="Feb"),C2:C11))}
I need to count the # in Column C when the criteria is met in A and B. This
is an array formula.
And I keep getting 0....