Count of NEW CUSTOMERS Q2 Q3 Q4

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
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-JUNJUL-SEPOCT-DECtotal
A198 Q1 109,800 xxx 109,800.00 1
A306 Q1 297,370 332,980 x12,500 642,850.06 2
B089 Q1 80,564 xxx 80,564.20
A419 Q2 new x348,750 xx 348,750.00 3
A424 Q2 new x1,172,055 335,600 58,430 1,566,085.00 4
D148 Q2 new x1,181,950 xx 1,181,950.00 5
A429 Q3 new xx174,870 x 174,870.00 6
A442 Q3 new xx10,518,090 x 10,518,090.00 7
P329 Q3 new xx1,522,500 6,880,250 8,402,750.00 8
B050 Q4 new xxx-32,100 - 32,100.00
start Q1newrepeattotal
Q1 xx0
Q2x 0
Q3x 0
Q4x 0
<colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;" span="4"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;"> <col width="21" style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;"> <tbody> </tbody>
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Forum statistics

Threads
1,216,077
Messages
6,128,685
Members
449,463
Latest member
Jojomen56

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top