Home > Forum Home > Developing Financial Accounting Systems > Excel Sum and Date help w/multiple variables Share

Excel Sum and Date help w/multiple variables

Excel Help for Excel Sum And Date Help W/multiple Variables in Developing Financial Accounting Systems


Forum TopicPost Reply Login

Excel Sum And Date Help W/multiple Variables

Rate this:
(3/5 from 1 vote)
ConfusedI am trying to create a statistical spreadsheet for my work that analysis information from 10 different pipelines and updates the statistics as the pipeline updates.

So far I have completed a few of the easy parts through Pivot tables that update when i open the excel sheet. I am fairly new to excel so i have been trying to figure this out by myself and am not sure what to do here.

I am trying to find the SUM of $ but in three different terms. Need rows 8-1000 for each variable.


Column A has a drop down box to choose from: ={Inbound, Outbound}
Column B has a drop down box to choose from: ={Pipeline, Converted, Not Converted}
Column C is a number that is inserted: = $ USD

I need to calculate:
                   Inbound           Outbound
Converted      $USD                  $USD
Not Conv.       $USD                  $USD
Pipeline          $USD                  $USD

--------------------------------------------------------------------------
Second Question: i have is a matter of converting dates and subtracting days.  My main problem is that whomever made the original pipeline excel sheet all of the employees are working off of, formatted it in a way that is hard to collect certain data.

For this part i am trying to find Time until conversion and time until failed conversion of the clients for both inbound and outbound. The problem comes from the dates being in 4 boxes instead of 2.

Column D is the Month of clients first contact from a drop down box: ={Jan, Feb, Mar, Apr... Dec}
Column E is the Date of clients first contact from a drop down box: ={1,2,3,4...30,31}
Column F is the Month of Conversion from a drop down box: ={Jan, Feb, Mar, Apr... Dec}
Column G is the Date of Conversion/Failed from a drop down box: ={1,2,3,4...30,31}

I need to calculate:
                                                   Inbound                    Outbound

Avg Days until Conversion               #Days                        #Days

Avg Days until Failed Conv.             #Days                        #Days


YOUR HELP IS VERY MUCH APPRECIATED!

Thanks in advance.

Kind Regards,

Pat
 Posted by on
 
There are currently no replies to the "Excel Sum and Date help w/multiple variables" topic of the Excel Help Forum for Developing Financial Accounting Systems.

Post Reply

Excel templates and solutions matched for Excel Sum and Date help w/multiple variables:

Solutions: Web Services Add-in