#value error

Hi All! I have tried to search for a solution, but I'm not able to figure out what I'm doing incorrectly with this formula. I can get it to work with one criterion but when I try to use two criteria, it doesn't work... Heres a small snippet of my table "AuditCriteria" Q3 = "Jan" Q4 = "New...

Hello Gurus, How can you delete/clear those cells that contains #VALUE! (note that it contains formula). So far I saw this code: = = = = Delete cell only If IsError(Range("C7")) Then Range("C7").Delete = = = = I have 10-15 tabs sheets and I need to run the macro like scan cells that...

I have a lambda function which will not let itself be included in a SUMPRODUCT depending on the YEARS comparison. All other parts of the formula are working but stick the LAMBDA function result in there and it just won't have it... Why ??? Row 5 in blue are figures as a result of the lambda...

Hi, I am not sure if there is a solution to this. I have a Workbook where I capture information. I have added some formulas ease the process. I have a Dashboard Worksheet that summarize some data. The formula is [COUNTIFS('Incident Register'!$B$5:$B$2001,'Data Sheet'!A4,'Incident...

Hoping somebody can help out...please :) I have a sheet that I want to do countifs on but when I put 2 working countifs together in one formula I get #value? 1. =COUNTIFS(Colleagues!$E:$E,$B$4) - returns the correct result 2...

I want to be able to calculate the rate/percentage of error. I have 3 sheets: Master, Co-Master and ReDo. Both the Master and Co-Master sheets have a total time column (J) to give the total time a user has taken to complete a task. The ReDo sheet is solely to record issues with the Master or...

I have a workbook that works perfectly when saved locally. Even with hidden data and "Protect Sheet" enabled, all is well. HOWEVER, when I save my workbook to OneDrive, and view the workbook online, all my functions return a #Value error. My worksheets have Review/Protect Sheet enabled...

Hey guys, I'm currently creating a room registry and encounter this error in one of my if function :error #value I tried to googling this issue but failed without luck. <tbody> type of room no.of night extra bed room price complimentary total </tbody> 1. under number of...

Dear experts, Having gone around for an hour, I can't figure out why my Sumproduct doesn't work. =SUMPRODUCT(--('Balance Sheet_Property SS'!$C$14:$C$271=$S$32),--('Balance Sheet_Property SS'!$D$14:$D$271=$S$30),--('Balance Sheet_Property SS'!$F$14:$F$271=$S$33),--('Balance Sheet_Property...

Hi Community, I have a formula that is leaving me stuck and I'm not sure how to solve it and hoping you can help. =IF(ISERROR(D50/D49),"BCB Auto-Fail",D50/D49),IF(AND($C$14,$C$18,$C$22,$C$26,$C$37,$C$40,$C$44)="---Select---","N/A") Issue: the formula should be trying to calculate that IF...

Hi Super-Brainers Can you help me decide what is wrong with this formula? It is giving me #value error. =SUMPRODUCT(1*($D$3:$D$354=$A4),1*(MONTH($E$3:$E$502)=$D$1)) Column D : Stages (e.g. Lead, Opportunity, Converted etc.) A4 = Lead Column E: Date corresponding to stage value from column D...

Hello all - I have been given some great help recently in trying to return the MODE of a series of TIMES (as in times of day). This has been very helpful, and I thank you all. Now I have hit a snag in implementing it. In col C2 I have the following formula: =IF(Main!DG3="X",Main!G3,"") This...

Hi guys, i have a formula which checks the value of a cell in the "Unique ID" columns against the "Unique ID" column in a different table. if its the same, I have it say Keep, if it doesnt exist, i have it so it says delete. however, a third value I'm getting is #value !. any idea why im getting...

Hi all, I have two data sets (two sheets in the same workbook) where I need to locate entries from one in the other one. Both sets are formatted as a Table and I am using an INDEX(MATCH()) combination to match entries. If match is found, values from one of the fields in Dataset1 should appear...

I have a project with a number of resources and different task to complete over a extended period. the maximum number of task assigned to an individual at one time is 7. I was planning to use a sum product which reference a drop down list of the resources,then task no, then date then tell me...

Okay, I am stumped (hence why I'm posting here). No matter what I do, I cannot get this formula to work. Here is the current bane of my existence: =IF(J7 < 25%, "Text 1"), IF(J7>25%, "Text 2"), IF(J7>50%, "Text 3"), IF(J7>75%, "Text 4"), IF(J7>= 99%,"Text 5") I have no idea what I'm doing...

I'm trying to concatenate two columns of cells in Excel 2010. One is the name of a supplier, the other is a 5 digit account code. Some of the codes are fully numeric and some are alpha-numeric. I'm using this formula: =CONCATENATE(A2, - B2) in order to get a dash between the two parts. It is...

Hey all I need some genius, I've been trying to find a way to swap an exception price with a generic item price for specific customers. I have two large databases, one with item codes/descriptions/prices (CC8-3465, CC16- 3324, MSO2-1456, etc.), and one with customers (1002 - Customer 1, 3244 -...

Hi! I have two rows with values and I'm using sumproduct to subtract the two. However I also need the formula to ignore empty fields and don't do the substraction if the lower field is empty. It seems to work when i use the insert function window, but once the formula is applied to a cell it...

I have a bit of a weird one so bear with me. I have an macro-enabled Excel spreadsheet (.XLSM) created in Excel 2010. On the first sheet (HoldsList) I have data formatted as a table called Holds (see below) with the autofilter turned on. What I'm trying to do is, using VBA, filter the table...