Search:

Tag: #value!

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. SumByColour displays #VALUE!

    Started by jshard‎, 12-05-2023 01:09 PM
    #value!, sumbycolor 3 Attachment(s)
    • 315
    Last Post: 12-08-2023 07:37 AM
    by Fluff13  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  2. Index Match error

    Started by YY1708‎, 10-11-2023 03:45 AM
    #value!, error, index, match 1 Attachment(s)
    • 226
    Last Post: 10-11-2023 05:17 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] Nested XLOOKUP formula returns #value error

    Started by mo1h43v‎, 05-10-2023 08:26 AM
    #value!, nestedxlookup, xlookup 5 Attachment(s)
    • 1,440
    Last Post: 05-11-2023 08:56 AM
    by mo1h43v  Go to last post

    Forum:
    Excel Formulas & Functions

  4. #value!

    Started by kivikatz‎, 01-31-2023 03:13 AM
    #value! 1 Attachment(s)
    • 281
    Last Post: 01-31-2023 11:09 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] #VALUE! Error Using a Triple Nested SUBSTITUTE Formula, ERROR DUE TO EMPTY CELL(S)

    Started by skite0‎, 02-23-2021 03:53 PM
    #value!, formula, substitute, sum - range of cells 2 Attachment(s)
    • 398
    Last Post: 02-23-2021 04:13 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  6. INDIRECT Function Gives #VALUE! Error on Reopening

    Started by Rob Bennett‎, 06-24-2020 08:21 PM
    #value!, indirect
    • 1,013
    Last Post: 06-25-2020 01:05 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Sumproduct formula returns #VALUE!

    Started by deniseturan‎, 11-19-2019 04:07 PM
    #value!, excel, mutiple criteria, sumproduct 1 Attachment(s)
    • 459
    Last Post: 11-19-2019 05:24 PM
    by deniseturan  Go to last post

    Forum:
    Excel Formulas & Functions

  8. SumProduct of common range on dynamic number of duplicate sheets

    Started by FrisoKoopman‎, 01-10-2019 09:06 AM
    #value!, dynamic, public function, sumproduct 1 Attachment(s)
    • 707
    Last Post: 01-10-2019 09:06 AM
    by FrisoKoopman  Go to last post

    Forum:
    Excel Formulas & Functions

  9. LINEST function only returns M and sometimes C values, all other values returned as #VALUE

    Started by Eroded_Plasma‎, 01-03-2019 03:10 PM
    #value!, error, linest, mac 2016 2 Attachment(s)
    • 5,793
    Last Post: 01-03-2019 05:40 PM
    by MrShorty  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] #Value!, combining numbers and text

    Started by luisvv93‎, 07-27-2018 06:37 PM
    #value!
    • 423
    Last Post: 07-27-2018 07:08 PM
    by jtakw  Go to last post

    Forum:
    Excel Formulas & Functions

  11. typed in same formula as in other excel doc, reads #value!

    Started by dv1651st‎, 07-18-2018 04:19 PM
    #value!, date, finances, sumifs 1 Attachment(s)
    • 601
    Last Post: 07-18-2018 04:54 PM
    by BadlySpelledBuoy  Go to last post

    Forum:
    Excel General

  12. What is in this blank cell??

    Started by lahatte‎, 10-19-2017 02:09 PM
    #value!, empty cell 2 Attachment(s)
    • 1,606
    Last Post: 10-20-2017 11:42 AM
    by davesexcel  Go to last post

    Forum:
    Excel General

  13. [SOLVED] I am looking to sum two cells on different worksheets and it returns #VALUE!

    Started by adam_d_john‎, 06-15-2017 02:05 PM
    #value!, #value! error
    • 430
    Last Post: 06-15-2017 04:28 PM
    by Jonmo1  Go to last post

    Forum:
    Excel Formulas & Functions

  14. =MEDIAN(IF(AJ$2:AJ$104=1,$AB$2:$AB$104)) function while the cells contain #VALUE!

    Started by erickwy‎, 04-11-2017 01:42 PM
    #value!, #value! error, function, median if
    • 650
    Last Post: 04-13-2017 02:13 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] VBA UDF Value Error

    Started by sdl5384‎, 09-27-2016 09:24 AM
    #value!, #value! error, udf, user defined functions, vba
    • 933
    Last Post: 09-28-2016 12:59 AM
    by sdl5384  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  16. Percentages multiplying problem

    Started by Puma1‎, 09-19-2016 09:43 PM
    #value!, calculations, error, multiplying, percentages
    • 626
    Last Post: 09-19-2016 10:01 PM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Index/Match Function Returns '#VALUE!' Error

    Started by VirenS‎, 06-17-2016 05:27 AM
    #value!, error, index, match
    • 805
    Last Post: 06-17-2016 05:36 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  18. Excel VBA function returning #VALUE! unexpectedly (and only occasionally)

    Started by novaraz‎, 02-06-2016 04:11 PM
    #value!, vba
    • 577
    Last Post: 02-07-2016 02:46 PM
    by joeu2004  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  19. [SOLVED] Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE!

    Started by Hedy‎, 01-13-2016 11:59 AM
    #value!, blank cell, existing formula, iferror, iserror
    • 910
    Last Post: 01-13-2016 12:05 PM
    by Hedy  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Very Simple Formula Error!

    Started by an Engineer‎, 07-01-2015 11:49 AM
    #value!, formula error, sheets, simple formulas, strange behaviour
    • 708
    Last Post: 07-01-2015 12:06 PM
    by bigroo1958  Go to last post

    Forum:
    Excel General

  21. [SOLVED] #VALUE! output when performing a simple calculation. Cell number formatting

    Started by Madasco‎, 04-29-2015 03:56 AM
    #value!, cell formatting, number formatting, value data 2 Attachment(s)
    • 735
    Last Post: 04-29-2015 06:53 AM
    by LokeshKumar  Go to last post

    Forum:
    Excel General

  22. Help: #VALUE! error using function macro to reference other network closed spreadsheets

    Started by Johnny Lawndart‎, 06-19-2014 12:43 PM
    #value!, error, macro, sumifcolor, sumifcolor macro
    • 670
    Last Post: 06-19-2014 01:03 PM
    by Johnny Lawndart  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  23. Indirect, Match, Address adding {} and "" when inbedded in Formula

    Started by Alex.riccio‎, 01-10-2014 11:38 AM
    #value!, address, indirect, match, {} and "" 1 Attachment(s)
    • 963
    Last Post: 01-13-2014 09:18 AM
    by XOR LX  Go to last post

    Forum:
    Excel Formulas & Functions

  24. INDEX function not working

    Started by bonifacio1124‎, 10-27-2013 05:00 AM
    #value!, formula argument, index, match, no value output 1 Attachment(s)
    • 2,183
    Last Post: 10-27-2013 06:41 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Match function returns #VALUE!

    Started by Joemoisslow‎, 09-10-2013 04:27 PM
    #value!, #value! error, excel2007, match
    • 10,088
    Last Post: 09-10-2013 08:17 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  26. #Value! shows in text box on top of chart until clicked on

    Started by socalboarder‎, 08-28-2013 01:31 PM
    #value!, text box
    • 1,107
    Last Post: 08-29-2013 12:44 PM
    by socalboarder  Go to last post

    Forum:
    Excel Charting & Pivots

  27. [SOLVED] Help with =TEXT(A40,"m/d")&"-"&TEXT(A40+6,"m/d")

    Started by clroxas‎, 08-12-2013 04:17 PM
    #value!, date, text() 1 Attachment(s)
    • 773
    Last Post: 08-13-2013 08:33 AM
    by Jonmo1  Go to last post

    Forum:
    Excel Formulas & Functions

  28. CHOOSE Function returns "#VALUE!" when using an array

    Started by wolf83‎, 03-25-2013 02:25 PM
    #value!, array, choose, range
    • 1,692
    Last Post: 03-25-2013 09:37 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] Having problems with =IF(ISERROR(),,) formula

    Started by Robioto‎, 01-25-2013 11:08 AM
    #value!, error, formula, iserror
    • 733
    Last Post: 01-25-2013 11:46 AM
    by Fotis1991  Go to last post

    Forum:
    Excel Formulas & Functions

  30. Creating averages by Excel automatically knowing what number to use in the denominator

    Started by HeathHarlan‎, 12-19-2012 12:14 PM
    #value!, averageifs, averages, error #div/0!, sumif blank empty 1 Attachment(s)
    • 902
    Last Post: 12-19-2012 12:30 PM
    by Melvinrobb  Go to last post

    Forum:
    Excel Formulas & Functions

  31. #VALUE! When using countifs with dates

    Started by jsgately‎, 12-03-2012 12:29 PM
    #value!, countifs, date & time calculation
    • 841
    Last Post: 12-03-2012 01:09 PM
    by jsgately  Go to last post

    Forum:
    Excel Formulas & Functions

  32. [SOLVED] Trying to subtract from a cell that contains an IF statement.

    Started by dzo1‎, 09-26-2012 01:39 PM
    #value!, calculations, data validation, if statement
    • 810
    Last Post: 09-26-2012 01:59 PM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  33. VLOOKUP multiple criteria

    Started by Heinrich Venter‎, 09-11-2012 09:19 AM
    #value!, and function, if function, vlookup 2 Attachment(s)
    • 1,779
    Last Post: 09-11-2012 10:40 AM
    by nageshpolu  Go to last post

    Forum:
    Excel Formulas & Functions

  34. #Value! error

    Started by dalaie‎, 09-10-2012 06:11 PM
    #value!, error, link cell 1 Attachment(s)
    • 936
    Last Post: 09-10-2012 07:32 PM
    by martindwilson  Go to last post

    Forum:
    Excel General

  35. [SOLVED] SUMIFS formula returning #VALUE!

    Started by Kuehl5000‎, 05-25-2012 03:49 PM
    #value!, sumifs 1 Attachment(s)
    • 1,108
    Last Post: 05-25-2012 04:11 PM
    by Cutter  Go to last post

    Forum:
    Excel General

Results 1 to 35 of 51
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1