subscription

Is it possible to use sumproduct and if statements together, or is there an easier way of achieving what I need to do here? I have the following formula: =SUMPRODUCT(--(Statement!$J$1:$J$1724=C13),Statement!$L$1:$L$1724) What this does is look at my bank statement sheet for a particular line...

Hi All, Please find the below descriptions which are 3 different cells (A1,A2,A3) Now i need to separate the dates which are highlighted below in BOLD into 2 different cells(B1 and C1) NOTE: All date format are in different format like (mm/dd/yyyy, mm-yyyy, mm-dd-yyyy etc) and also there was no...

Hi all, Hoping for some assistance here. Attempting to create a macro which takes data from several points on one line and populates a different spreadsheet with the relevant data, then goes to the next line and repeats. I've managed to get it working as intended, the only problem being...

Hi Guys hope all is well i have the below table at work with data and forumla, and i need help understanding 1) what the formula are doing 2) if i can improve these formula ( is there a more efficient way to do this. <tbody> A B C D E F G H I J K 1 NAME START DATE END DATE TOTAL LENGTH...

Hi I have the following: Dim mySUN As Workbook Set mySUN = Workbooks("c:\SUN\Get_Sun - 2018.xlsm") I receive an error -->subscription out of range I would like to correct this. Thanks!

Hello, New member to the website! I have attempted several searches for answers to the request and it looks like none of the threads have an answer to my question. I am looking for a formula to determine what the total cost of a subscription would be over a given period of years if the...

I have the following sales data for 2016, 2017, and 2018: <tbody> Column A Column B <strike></strike> Column C Column D <strike></strike> Column E Column F <strike></strike> Column G Column H <strike></strike> Column I Column X Row 1 Opportunity Name Opportunity Close Date (US date)...

Hello everyone, I have a table that the first column is the column of a subscription number and all other columns are currently empty, I have defined that if I double click on one subscriber number, a form will open Then fill in all the data of the same subscription number (eg first name...

Anyone help with my confusion... I have Excel 2016 ( office 16 ) installed and I also just bought Office 365 but it was a "click to run" version as I found out. I'm really wanting the new insert icon features and have seen some info on Google that you only get this with a subscription package...

Hi I am trying to work out if a subscription has recovered during a period. I have three tables, date, subscription and customers. If a subscription churns (does not renew) at the end of the subscription period however within a 12 month period returns (from the end date of the subscription)...

Hi I am trying to work out if a subscription value has done one of the following: No change - no change from current month to previous month New business - did not have a subscription the previous month and current month has a subscription Upsell - current month subscription is higher than...

Hi Guys! I have a problem which I hope one of you can solve! I think it will be a tough one. I have an Excel with multiple tabs of users in subscriptions. Each tab contains different information about the users (account permissions, normal permissions and settings). I need to group the users...

Hello All, I am not able to add a percentage column in a pivot table. My data looks like this: Name Location Call Date Subscription Date State Country John Hackensack 4/4/2017 4/29/2017 NJ USA Peter Fort Colins 4/7/2017...