value error

  1. M

    SUM if for separate sheet

    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...
  2. M

    Help with #value! error

    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...
  3. A

    User Defined Functions returns #VALUE after a macro is run

    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...
  4. M

    Value error when trying to copy down a formula

    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...
  5. S

    sumifs, sumproduct: Do they work with dynamic named ranges?

    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...
  6. K

    Conflict with variables with the same value?

    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...
  7. L

    Cannot run VBA code?!?!

    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...
  8. R

    Concatenate

    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?
  9. A

    MoreFunc Add-In Value Error in HSORT and VSORT

    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...

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top