4

Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form.  In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this..

1

HI everyone,

I am trying to create three formulas on a sales pipeline. 

The first is I am trying to track for the month of July how many deals we have that are opportunities. Then I am trying to track for the month of July how much revenue in deals we have that are in the opportunity stage. I then

6

Hi there I need a formula that will look across rows and columns in a table. 

For example,  I need the result for School District-B with 23 items. The result from the table below should populate with: $350

                                         1-5       6-15    16-25    26-50   51-100