In coloumn A some cells contain "Y" coloumn F also has cells that contain a "Y" i would like to know how to sum which same rows in A and F contain "Y"

I have a conditional format in place on sheet1 that highlights the entire row (data in Col A - Col L) if there in text input in the cell of Col D. My task...

Does anyone know an Alt key combination to enter the infinity symbol?

I have a spreadsheet that i want to hide columns a:H if the value in cell L1="N" and unhide if theres a "Y". i'd prefer for the "macro" to be real-time...

I have a following formula to extact text string. =IF(ISERROR(SEARCH("Blind Discount",A3)),"","Blind Discount") I want to add one more criteria. If the text...

How do you state this as a formula? If A4:A8 is the number 23, then add only the hours in B4:B8 that go with 23. A B 23 1.5 15 1.0 17 1.0 12 ...

I have a workbook that has the first sheet named ‘totals’ and 20 other sheets which are named as employee names. The totals page sums all the numbers of...

calculat earnings on savings. what would be the yearly earnings for a person with $6.000 dollars annual interest rate of 5.5%. Show calculated fomrula

I have worksheets where I have a formula to calculate the number of years and months of service. I would like to use that date to calculate excess annual...

I need what I sort on page one to sort on the page I have it linked to and carry over all information. It sorts on the linked page what is in a specified...

Hi, I use spreadsheets daily and for months now I have been having an issue where all my cells that are formatted as 'General' change themselves to...

A little background first. I have this formula =IF(OR(Area!A4="Chainage", Area!A5="Base Area:", Area!A5="Total Area:", Area!A5=""), "",...

How to sort data containing formula For example Column A Column B Column C 1 10 =B1-B5=4 2 9 =B2-B5=3 3 8 =B3-B5=2 4 7 =B4-B5=1 5 6 =B5-B5=0 Now if I sort in...

I have a start and stop date. I want to see if any part of that start/stop range falls within another date range. Start: 9/15/09 End: 10/1/09 Date range...

I expect there is any easy answer to this but I am basically wanting to copy the details of one worksheet into another. Using the basic '= Sheet 1! etc.'...

Help please....I am trying to compare data in 2 sheets to get the difference from month to month #1 (previous month's forecast) Customer Part number ...

Is there a way to make date formats read 1/1/2009 when you converty them to mmm-yy, instead of them staying at their original format. Basically, if a cell...

Hello, I am linking the data from one sheet in my workbook to another, and previously the way it was set up was to use the offset function. So, the data in...

Hi Could you tell me how i can use the sendkey command in VB to switch to a particular, open internet browser. For example: If i have google open in one...

I currently have a workbook set up with various tabs, ideally id like to find a way that when I am entering text, ie a surname in a cell it will prompt me if...