Search results

I've seen some references to SUMPRODUCT as a non-array type of formula that might be used for this but I can't get it to work.

Hi Jeff, I don't have a way to post my spreadsheet online. Those articles don't seem to address the combination of calculations that I am trying to get. I need to combine a sum of all records in a date range and reduce that sum by the amount of records holding a unique value in a phone...

Hello, I am looking to get a count of unique calls (phone numbers) in a date range. Sheet2!K:K is the Date Column Sheet2!O:O is the Phone Number Column I am trying to get all unique phone number values between a date range of 5/1/2013 and 5/14/2013. Can anyone help? If possible, I am...

I have tried: =VLOOKUP(P66,Sheet1!B1:B50,11,FALSE) and even from another workbook: =VLOOKUP(P66,'[Seminar Schedule.xlsx]Sheet1'!$B1:$B500,11,FALSE) I get a #REF! error

I have used SUMIF in the past to show numbers for this but I can't figure out how to show text. Example: =SUMIF(Sheet1!B:B, "P0227", Sheet1!K:K) This only works with numberical values. Is there some other sort of equation that can do this with text if there is only 1 instance of the...

Hello, I am trying to display a value from Sheet1!K:K if on the same row Sheet1!B:B is equal to a text value of "P0227" or field P62 on my main tab. Can anyone help?

Thanks Narayan! That works great!! My sincerest appreciation!

Hi Narayan, I am still getting a total of 0 with: {=SUM(IF((I:I="(866)409-2388")*(K:K>=DATEVALUE("3/1/2012"))*(K:K<=DATEVALUE("3/31/2012")),1/COUNTIFS(I:I,"(866)409-2388",K:K,">="&DATEVALUE("3/1/2012"),K:K,"<="&DATEVALUE("3/31/2012"),O:O,O:O)))} I really appreciate your...

Thanks SirJB7, I will have to look up helper columns and how to identify unique values. The hard part for me is incorporating the date ranges that I need to count the unique values for. Thanks Narayank991, I have used the above formula you provided and came up with...

An example of the function I used to get the Total inbound 800 line calls in a date range is: =COUNTIFS(Sheet2!I:I,"(866)409-1365",Sheet2!K:K,">=3/1/2012",Sheet2!K:K,"<=3/31/2012") I need to add into this to count only unique values in the field Sheet2!O:O If that helps. Thanks!

Thanks oldchippy, I have done so.

Hello, I have a really complicated issue. I am looking to count the number of unique phone numbers in a date range, for a unique inbound 800 line. So one column Sheet2!O:O contains the phone numbers and another column Sheet2!K:K contains the date ranges, and Sheet2!I:I contains the unique...

I have a really complicated issue. I am looking to count the number of unique phone numbers in a date range, for a unique inbound 800 line. So one column Sheet2!O:O contains the phone numbers and another column Sheet2!K:K contains the date ranges, and Sheet2!I:I contains the unique inbound 800...