I have constructed this
=SUMPRODUCT(--('Sites_A-K'!G:G=A2),--('Sites_A-K'!I:I< (date()-60)))
in my attempts to count the rows where column 'Sites_A-K'!G:G = A2 and
column 'Sites_A-K'!I:I is less than today minus 60 days.

I have a list with entries like so:
1990CJ000123
1991CJ000124
1992DJ000124

Have lots of sales data, and would like to have a column display the
most recent price for an item.
Source data includes many shipments for various items, along with cost
and burden figures.

I posted before with a problem which was answered and then tacked this onto
it, but I think it's worth starting another thread as it has gone unanswered
(probably already consigned to history by most!).
I have a workbook for all our capital projects. I have simplified it to

My problem:
I have a workbook (wb1) where the formulas reference to another workboook
(wb2). Wb2 is placed in another folder. The formulas then comes out like this

I have a text string as follows LAST NAME, FIRST NAME
Smith, John.
I need to put the last name in one column and the first name in another
column. I can do it for one cell using the left or right formula. But I have

Doing a simple formula Cell A-Cell B and when I change data in cell A or B,
the total is not changing automatically. I event started a new excel sheet
and it is doing the same thing.

I want to convert a number like 12.56 to read Twelve Dollars and 56/100

Does anyone know if there is a function to display the worksheet name within
the worksheet?

I would like to set up a lookup table.  when I enter a value in the
spreadsheet, it will find the match value on the column A and print out the
value of column B.
See below

Conditional formatting. I want to add all those values where column name is
F02 and row name is Federal in a given area not the whole worksheet.

I am trying to do a vlookup where the format of the origin cells are
"general" and the format of table array is all in text.  I am looking up a
combination of alpha and numeric characters on the origin.
I know I can't look up 2 different formats but want the vlookup formula to

I want to be able to change the size of a cell and hide what is typed instead
of it changing the cell size to show what is typed

I have two pivot tables that get there source data from different files. I
would like to link the fields from both pivot tables into one spreadsheet
that will update when the pivot tables are updated.

How do I change the color of the entire row, if one of the columns in the row
meets 1 or more criteria?  I am able to change the color of the cell, but not
other columns currently.
Thanks.