I'm looking for a formula to Sum a column based on criteria from two other columns. I have five columns: Project Name, Actual Cost, Division, Phase. I want...

I am given average hours per day worked and I have to give an average hours and minutes per week and a YTD weekly average. I can't seem to get excel...

Hello, Is there a way by which I can make the contents of a comment box dynamic, i.e. based on the contents of one or more cells in the spreadsheet? My...

I have one column with a formula in multiple rows within the same column. The formula pulls data from other parts of the spreadsheet or leaves the cells blank....

Is it possible to use =address to supply the cell addresses for the range in the average function. I can get all the pieces to work separately but can't nest...

Hi. I am trying to get a pivot table to subtotal a row of data in the pivot table. I can get it to add columns at the end of the report with the subtotals...

I'm trying to sum a col of rainfall values that contain - numerics - numeric preceeded by an * e.g " *0.2 " - text such as "Trace" This works OK until...

Can anyone help please with how to hide #N/A please? I have tried conditional formatting but cant get the settings right. -- Kind Regards Mick ---

Can someone help me calculate the interest rate (or implicit rate) on the following cash flows? It should be a negative #, due to the residual. (the first 6...

Dear Domenic Thanks. It was easy but informative. Regards, Rasoul

Hello - I have a situation in which I need to get the top 2 revenue values based on 2 different conditions (office and position). I can get the first easily,...

How would I enter a conditional format formula with an OR statement? I would like to have a cell change to a specific colour if it is equal to 15, 20, or...

Yes, my cat must have stepped on the key. Thank you. Carol "Chip Pearson" wrote: Use the arrow keys. Most likely, the Scroll Lock is on which causes the...

You've been given solutions for what you asked for, but in general, it's poor practice to return expected "errors" as errors. If you trapped the NA error,...

It sounds like your hyperlink is still there, but the cell isn't formatted in a hyperlink style. Select the cell and hit Insert|Hyperlink (or ctrl-k) See if...

Thank you for your help, it seem function one of part. I also prefer when I change sheet2 "A2" value to 3.2.2001, the sheet2 "C3" value will be changed to...

I have ben tasked with revising some price sheets for our company. I am having problems removing the hard border which is aroud the spreadsheet. Have gone into...

I designed a spreadsheet to do these basic formulas, but what I wanted my students to do was look at my spreadsheets and try assess what I was trying to work...

Hi Press Alt+F11. Insert Module. Copy and Paste the below. Public Function FontBold(MyCell As Range) As Variant FontBold = MyCell.Font.Bold End...

Hello. I have a worksheet that is like a calendar, with a column for each day. I want to keep track of past days and also to show future days, exactly like a...