#na error

Hi All, I have a code that works great for returning information from cells that contain numbers derived from formulas, but not when one of the values can be "" or NA(). The code is =SUMPRODUCT(($G$6:$M$9)*(F6:F9="butter")*(E6:E9="low")) The layout looks like: <tbody> high eggs 33 31 38...

Hello, Looking to implement a sumproduct across 2 variables and i cant get my head around why its returning a #NA, can anyone help? I have colour in column and Demand across the top as below: <tbody> Demand £ (LW) Demand LW -1 £ Demand LW -2 £ Demand LW -3 £ BLACK #N/A BLEACH WASH...

Has anyone had an issue with or know how to resolve an issue where VLOOKUP returns an #NA for a value that is known to exist in the array when the lookup_value is the output of a TRUNC function. Basically I have... column E as a percentage ie. E3 = 35.7278134665715% and column F is using the...

Hello all, I have a spreadsheet with several tabs for different sites for the company. Not all sites deliver the same service items, but most do overlap. Service items are provided at several levels, again, not all the same levels are provided by each site. The maximum is 8 levels for any of...

Hey all, I am not sure what is happening. I have used this function a bunch of times and it is giving me a #na. My function is =HLOOKUP(D2,BL!$A$4:$D$17, MATCH(Sheet6!$C$1,BL!$A$4:$A$16,0), FALSE). D2 is 13 and c1 is JUN. It should be returning the number 5 but it is giving me an #n/A. What am...

All, I am having a problem with my Vlookup formula. I am using a date picker (MS Date and TimePicker 2.0 (SP2)) on sheet "Overall" to select a date. The range is set at 1/1/2014 - 12/31/2014. I am using the Linked Cell property and set it a AA1. I have a table on tab "Data" that grabs data...

Hi, I'm trying to create a timekeeping spread sheet for staff. I have a start time column, and a finish time column, both formatted as hh:mm and have entered the time using 24 hr time. I've used the third column to calculate the hours worked using the B2-A2 (Finish time - start time). All of...

I am having a problem with an Excel model which is crashing when I run my code because a formula is not evaluating properly and is resulting in the value #NA. I use some code to enter a formula in a series of cells. It uses a couple of vlookups to form a string value that I will use for a http...

Hey Excel Gurus- Hopefully this is an easy one for you. I just need a simple average formula but my data contains numeric values, zeros (that I need calculated into the average) and #NAs that I DON'T want calculated. Is there an average formula that will add up all numeric values including zeros...