Excel: Count of NEW CUSTOMERS Q2 Q3 Q4


The formula on J2 is =IF(H2>100000,COUNT(J1:J$1)+1,"") What are the formulas on D15, E15 16 E17 , F15 F16 F17 on the data below

acc acc name quart JAN-MAR APR-JUN JUL-SEP OCT-DEC total
A198 Q1 109,800 x x x 109,800.00 1
A306 Q1 297,370 332,980 x 12,500 642,850.06 2
B089 Q1 80,564 x x x 80,564.20
A419 Q2 new x 348,750 x x 348,750.00 3
A424 Q2 new x 1,172,055 335,600 58,430 1,566,085.00 4
D148 Q2 new x 1,181,950 x x 1,181,950.00 5
A429 Q3 new x x 174,870 x 174,870.00 6
A442 Q3 new x x 10,518,090 x 10,518,090.00 7
P329 Q3 new x x 1,522,500 6,880,250 8,402,750.00 8
B050 Q4 new x x x -32,100 - 32,100.00
start Q1 new repeat total
Q1 x x 0
Q2 x 0
Q3 x 0
Q4 x 0


This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of January 03, 2014.


For more resources for Microsoft Excel