value error

Hey all, So I have a few formulas that run in the background of a workbook that is used at my work and keeps track of progress/amount of work done by different people in my department. I am trying to make some tweaks/additional adjustments to the formula, and it's getting hung up but I can't...

It is probably a simple answer that i just have not been able to see. I have converted everything in my spread sheet to inches, then did the formula to find square ft. - No Problems there What i need to do is " lets say A1 = 66 and A2 = 66 The Sq. Ft. it gives me is A3 = 30.25. I need to...

I have a workbook that has two sheets. Sheet one is in color and there are six timecards on it that all fit on one screen. Sheet 2 has those same six time cards, organized vertically instead of horizontally, and all the color formatting has been removed for printing. The idea is that everyone...

Excel 2007. I have a workbook with three main sections that share information. 1. Project sheets. These have random sheet names and contain project information. In cell S16 I am calculating a start date based on project type and status. I am checking to see if cell 108 is filled in to...

Hi people, I a new here and i have a worksheet with several buyers in sheets. I need to hv one sheet in which i have for evry byer how much certai goods did he take. Crteria is month, type of goods. I am stuck on SUM IF formula which is giving zero or VALUE error Here is my formula...

Hi, can someone help with this error in excel. My formula is IF(WEEKDAY(DATEVALUE(MoMonth&" 1, "&MoYear))=COLUMN(B$2),1,IF(LEN(A6)>0,A6+1,"")) but cannot manage to solve it by meself. Its a week planner that adds the correct date and corresponding task to the day. Any help is much...

Hi everyone, I am using the following User Defined Function to count the number of indents in a cell. Public Function IndentCount(rCell As Range) As Long IndentCount = rCell.IndentLevel End Function However, I am having a problem with the function returning #VALUE after I run the macro...

I know there are a lot of threads about macros to copy formulas but I haven't found an answer to my specific problem yet. So, I've been using this macro Sub FillDownFormula() Dim LR As Long LR = Range("J" & Rows.Count).End(xlUp).Row Range("A1").AutoFill Destination:=Range("A1:A" & LR) End Sub...

I have created dynamic named ranges using cell reference and index formula. e.g. $a$1:index($a$1:$A$300,counta($a$1:$A$300)) I used those dynamic named ranges in sumifs and sumproduct (because in sumifs it didnt work, I tried sumproduct also) like...

I'm working on writing a function for growing degree days (sine wave if anyone is familiar) and I have just one little snag that's been bothering me. The sheet is set up with two columns, minimum and max temperatures and the formula SinehalfDD is used for each row. The problem I have is that...

Hi I have a problem running VBA code. My colleague has programmed functions (modules and classes), but it simply does not work for me. I know that the code is ok, but maybe I got some Excel properties wrong...? The cell calling the function simply returns '#VALUE!'. Do I have to allow for the...

I'm trying to use the concatenate formula but it keeps returning a "#value" error. My formula is as follows: =concatenate("K",c12,d7,e9). c12=902, d7=E, e9=1. So concatenate should return K902E1. Any advice?

Greetings, this is my first time on MrExcel forum. I have a problem that I have not been able to solve and I was hoping that someone else may have had a similar experience. Here is my problem: Yesterday I installed the morefunc version 5 add-in, downloaded fine (from CNET), installed fine...