Count customer number when date and store loc. no are true

[oliverkat]

Any super users out there?

I got i work sheet that shows: A Company code, B Custommerid, C ship to, D
Ship date.

I like to create a formula that is able to show the number of shipments have
been made to each customer from each company on each date in the ship date
column.

Have tried the COUNTIF and the SUMPRODUCT but I am stuck and need some
qualified help to solve this problem.

 

[JE McGimpsey]

Any super users out there?

I got i work sheet that shows: A Company code, B Custommerid, C ship to, D
Ship date.

I like to create a formula that is able to show the number of shipments have
been made to each customer from each company on each date in the ship date
column.

Have tried the COUNTIF and the SUMPRODUCT but I am stuck and need some
qualified help to solve this problem.

Sounds like you should be using a pivot table - *much* easier than doing
it via formulae.

If you've never used them, Debra Dalgleish has a good intro here:

http://peltiertech.com/Excel/Pivots/pivottables.htm

 

[oliverkat]

Thanks, but this is the first step to create a formula to be used in a master
file that is to extract the data from a external report. The final result
shouls show the number of shipments made for each date shown in teh report:
like 23 single shipment, 19 double shipments etc.

My first thourght was to count the numbers of shipments per Company code and
Cust Id and date. It works with this formula:
{=SUMPRODUCT((($A$2:$A$30=A2)*(($B$2:$B$30=B2)*($D$2:$D$30=D2))))} it gives
the count on each line with same cust Id and date. Now I ned to count the
number of 1, 2, 3 etc per day to get a extract that shows the total of each
1, 2 3, etc per date/day.

I am not familliar with the Pivotables, can they be used in a automated
procces?