returning

Hi there, My formula is not returning what is should be returning. I've checked it over and I think it is good. =SUMPRODUCT((COUNTIF('Data Sheet'!1:1,'Data Sheet'!1:1)-1)*('Data Sheet'!1:1<>""))>0 Can anyone tell me what is wrong with it?

I use the googlefinance function in google sheets to import financial data from into an excel sheet. Since last night london share tickers were returning #N/A. I've change my tickers from the form "ABC.L" where the L is for london to "LON:ABC" and all has come good. Hope that helps someone else!

Hi all, I'm in the UK so 1st march is 01/03/18 ...everyone else is wrong! Including excel it seems. I am using =text(month(A5),"mmmm") which is returning January. Strangely =month(A5) returns 3, its the text that's converting it to 1 I've tried =text(month((A5)+3,"mmmm") still produces...

Hello all! Just started learning more formulas and VBA scripting for my job, but I'm running into an issue with the SUMPRODUCT formula returning 0 instead of the actual number. My intent was to have this run through the specified closed workbook and range and then return the number of cells...

I have an Excel workbook (financial model) with several tabs, circular references and iterative calculations activated (1,000 max iterations and .0001 max change). I am having a problem show up in numerous places in my workbook that is causing issues. A particular cell is referencing the value...

hi im using the following within a workbook =VBAProject.Module3.SumByColor(F152,J3:J95) it keeps returning zero.... I have figures in col J3 thru J95 any help will be appreciated... thank you

Hi I am trying to get data from a cell and need a little help. sSQLSting = "SELECT * From (" & Sheets(SpreadsheetName).Cells(firstAddress, Colname + 2) & ")" This is returning nothing? Any help would be appreciated.

Hi all, Looking for some help on a formula to find the highest values in a range then returning a 1 against the name.

Excel 2010ABC18First NameLast NameAmt19JohnJohnson15,000.0020SmithSmithson850.0021JamesJemson17,520.0022kenJemson16,500.002324John Johnson&lsqb;URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=VALUE&rsqb;#VALUE&lsqb;/URL&rsqb; !25Johnson...

Hi, I'm trying to SUM data subject to a "greater than" condition. I'm not using SUMIF because my calculation is not a simple sum and I also need to use an array, which I don't think is possible. My equation was like this: =SUM(IF(Sheet1!X$8:X$12431>100000,Sheet1!BF$8:BF$12431)) However, it is...

I am having issues with formatting. I have a sheet that I am working on for work and there are formulas that are returning 0's because there is no data to calculate (Example: 0/0=0) verses it returning a 0 because the calculation is 0 based on the data ( example: 0/2=0). I have to format the...

Hi, I have the following formula; =IFERROR(INDEX('Clinical-Treatments'!$P$12:$P$312,MATCH($D30,'Clinical-Treatments'!$M$12:$M$312,MATCH($L30,'Clinical-Treatments'!$D$12:$D$312,0))),"") P12:P312 are text values M12:M312 are numbers D12:D312 are dates The formula is returning a match for the...

Hello All, I am searching for a value with a vlookup that can range from 0-999. Occasionally the value will not exist so I am returning a value of 1. =IFERROR(VLOOKUP("*"&M12&"*",EPN!$Y$14:$Z$40,2,FALSE),1) The cells I am referencing are as below for the 2 fields. However I am getting false...

Hi Guys, This will be fairly easy no doubt, but I've already wasted an hour+ trying to come up with a solution so any help is of course appreciated. I have a column of numbers (let's say A2:A20) which are populated randomly by integers between 1 and 100. These numbers in actuality are the %age...

Hi all, Here's the formula that's not working... =COUNTIF(AK52:AK35533,CONCATENATE(T$4,U$4,"??16??m1")) Stumped! THANKS for your help! Jack

Hi guys, I have this formula which is not returning any results =SUMIFS($E$4:$E$339,$D$4:$D$339,"="&K$3,$C$4:$C$339,">"&$J4,$C$4:$C$339,"<="&$J5) Column E are Values Column D Names of staff Cell K3 Name of specific staff member Column C are Dates Cells J4 and J5 are end dates of two months...

Let me preface with saying I'm no rookie to INDEX/MATCH and use this function often. I am trying to sum two values returned by the function - I am using the same arrays in BOTH FUNCTIONS and searching for the same value in both columns the second Index/Match function is returning a cell 4...

Hi Folks, Not used excel in a while and my brain is hazy from the weekend so hopefully the good folks of MRexcel will be able to steer me away from potential wasted time by helping me out with a few simple questions. I have 2 tabs on a spreadsheet one with data in and one the summary sheet...

Hello Mr. Excel community! I am at a lose. I have this formula in one workbook and it works flawlessly. I am trying to add it to another workbook with the appropriate changes. But I am not getting the desired result. I am hoping that someone who hasn't stared at the workbook for endless...

Hi, Please could someone help me? I have the following problem: <tbody> A B C D E F 123 456 hhhhh 126 K 2 789 012 xxx 216 P 17 </tbody> I would like once I enter the QTY in column D and then select the letter in column E the sheet will automatically know what to put in column F. I...