I am trying to add a total in 2 sheet if date in 1 sheet is <= particular
criteria.
the following is my function call
=SUMIF(List!$B$2:$B$65536,"<= A2",List!$C$2:$C$65536)

I need to match the date,match the names of city's , return the kilometers.
The date has different city's as a reference so I need to match the city
that is
entered in B2,B3,B4,B5 and so on , in my worksheet.

Can anyone help me with the following:  I would like one of the cell
on my spreadsheet to reflect the greater of two values.  In othe
words, let's say cell A1 contains the value 23 and cell A2 contains th
value 24.  How do I make a third cell, i.e. cell B3, automaticall

How do I convert the firgures (numners) in to words in Excel?  In Word we
have CardText\*

I have a consolidated information of month-wise subscriptions in Sheet1
A1 Sl.No
B1 GPF Accounts No
C1 Ledger No

i am using a formula
in c1
if(a1="a","***","")
sometimes the formula fails in subsequent rows

Hi all, I have another formula that I would like some assistance with.
Currently I use about 14 income accounts, all of which have a unique 2
letter code to define them.
I have a spreadsheet that's about 30 lines deep per day with the

The subject says it all.  I want to search a range for cell values that
are < 0 and if they are, change the value to 0.  how do i do that?
thx

I need to find specific words in a cell in a worsheet in a column
and change the cell to equal “L3”

It keeps adding all the totals in all of the column. Don't want that. I want
to keep an individual cumulative total for each row for inventory of that
product.

I would like to subtract hours, not time of day and have it end up in h:mm
format. currently I am subtracting a cell with hours in h:mm format from a
cell in number (0 decimal places) format with the following formula:
=((HOUR(E18)*60)+MINUTE(E18)-($I$8*60))/60

Is it possible to have the checkbox value (either checked or unchecked)
dependent on if the number in another cell is positive or negative (greater
than or less than zero)?
I've tried the "cell link" option on the "control" tab of the format control

Is there some way to get #VALUE! recognized as one of the conditions of an IF
function argument?  For example, if D3 shows #VALUE! (as the result of a
"value error"), then one could ask, =IF(D3=#VALUE!,"bark","bite") or possibly
=IF(D3="#VALUE!","bark","bite"), and the result ...

I have an excel spreadsheet that I am doing and it has about 100 sheets
within the spreadsheet (tabs on botom) Is there a way to sort those sheets?

I need to have my cell be a drop-down menu itself, and have the options
reference a list in another sheet in the same workbook. I have a workbook in
which it is done, but I can't figure out how they did it. I can't put a combo
box over the cell, because then my vlookup formulas ...