I have a sheet with a list of items. One column has a description and I need
to find all the description cells that contain "North America" for example.
What can I use.
Thanks and Regards

What I'm trying to create is a formula where if the number in C2 (x) is
greater than 50, calculate x-50=y, add sum of D2*50 +(y*(1.5*D2))
Thanks in advance for any help you can offer!

There is a little red arrow in the upper right hand corner of work sheet
block with my name in it.  How can this be deleted, removed, etc?

Hello out there.
I need a formula to count a specific occurrence of an abbreviation, with two
criteria being met.
For example

I am working on a report in which i have gone through the forumla
{=SUM(IF((('Open Detail'!$B$2:$B$5210="FMS")*(('Open
Detail'!$F$2:$F$5210="IR")+('Open Detail'!$F$2:$F$5210="PR"))*(('Open
Detail'!$O$2:$O$5210<2))),1,0),C13,D13,E13,G13)}. I am not able to understand

I need to create a spreadsheet for my boss scoring the length of calls.  4:32
means 4 min and 32 secs.  The formula needs to have the following for scores:

4:31-5:00= 2 points

I need a formula to calculate the number of payments remaining on a loan
based on constant interest, constant payments and a known balance.  I am
trying to use the NPER function but it doesn't give the right answer if I
change the interest rate.  How many payments do I have left ...

I have a worksheet with names on it. Every name is positioned above a
list.
I created a Name with the following not continuous range: sheet1!$B
$5,sheet1!$G$5,sheet1!$L$5 etc.

can anyone tell me the formula I need to enter if I have a cell test which is
"flat" then turn a different cell yellow?

I’m doing a spreadsheet where I have a list of Office locations, when I
choose a location I would like the relevant server name to appear in the cell
of my choosing (i.e. C3)
I’m not sure how to go about this and was wondering if anyone knows the

I have the budget split on monthly basis & I want a formula that when I
update the sales it will calculate to me the budget till that month.
Example if the Cells w11 to z11 contain the sales figures from Jan to April,
the formula should sum the budget from Jan to April b11:e11.

I have a problem that i can't solve and i hope someone can help me...
I have this matrix
    A         B
1  JJ         45

How do I retrieve the url portion of a cell that has a hyperlink stored int
it.  The value function only returns the readable text.

I want to use
=SUM(SUMIFS(W:W,L:L,{"DR","SS"},S:S,B5))
which works but I want the {"DR","SS"} arguement to come from a cell
reference. i.e =SUM(SUMIFS(W:W,L:L,C5,S:S,B5)) where C5 is {"DR","SS"}.

I have three columns of data:
* ColA contains arbitrary text identifier values, in groups of four.
* ColB contains arbitrary integer values, which can be negative, zero, or
positive.