Thanks Narayan, this is exactly what I needed. I expanded it to include [Counted]:
=SUM(IF((customer_time[Extensions]=M$1)*(customer_time[Counted]=1)*(customer_time[Date Int]>=mtd_start)*(customer_time[Date...
Thanks Faseeh. This is a good start, but I think it counts the total number of dates that meet the criteria but doesn't narrow it down to unique dates. I updated the example doc w/ a pivot table that I believe calculates the correct answers (11 for L2, 8 for M2, 0 for N2). Is there a way to...
I know there are quite a few post on this but I haven't been able to get any of the solutions to work.
I have a table of call logs w/ the employee extensions (customer time[extensions]) in one column and dates (customer_time[date int]) in another (converted to an integer so the time data is...
We're paid an upfront annual commission (avg comm/deal) for each client. On month 13, we start to receive a monthly commission (avg comm/deal / 12) for each client. We also have certain costs associated with obtaining each client (Total cost/deal). Each of these is variable & can be changed w/i...
I fixed 5 sheets in like 1/2 an hour thanks to your info! After puzzling over the code for a week, it *was* a little vindicating to find that the error wasn't in my code but in the data itself.
Ok, that makes sense. I was confused that the watch value didn't change depending on whether was...
Amazing! ? united.name gave an error. The sheet was named "United National" with the object name as "United_National" so when I changed both to just "United" it worked.
Thanks a million not just for helping me solve this problem but teaching me what to look for so I can solve future issues...
Wow, this info is awesome.
Ok, using the immediate window `? rate_str' shows the correct value right up until
Dim Area_range1 As Range, Area_range2 As Range
Set Area_range1 = United.Range("United_Area_1")
Set Area_range2 = United.Range("United_Area_2")
'Now we search the...
I hope you will do me the favor of giving me another tip on debugging...
I set up some watches (any command that was rate_str = ) on another similar file & experimented with setting the breakpoint. When I set it at
rate_str = rate_str & "_" & Tobacco
the watch values are False (no...
Asa:
First, thank you a million times for confirming I'm not crazy. I've been tweaking that code for a week & I was sure it looked okay. I can't believe something as simple as a dash is responsible for nearly driving me insane! The info on the Constitution sheet is usually copied or exported...
I'm having trouble with a custom function that pulls an amount from a worksheet based on factors entered on the main sheet (age, zip, etc). I've updated these on several different workbooks(we have one for each state) before with no problem but this week none of the ones I've added seem to work...
I apologize in advance as I suspect this has been answered before but I'm just not searching for the correct terms.
I have a table in worksheet with a list of policy information (status, account #, name, date, etc). In a second worksheet, I'd like to autogenerate list of all accounts that have...