Need Help with a Sum/count formula

[Jonker19]

Hello all,

I have a issue with a formula that I cannot seem to figure out.

This is a running monthly list. I need to sort 2 levels of information and end up adding up a third numeric column

DATE - SEA SHIPMENT - # of Part Number shipped
DATE - AIR SHIPMENT - # of Part Number shipped
DATE - DIRET SHIPMENT - # of Part Number shipped


EXAMPLE:
A B C
5/3/05 - SEA - 50
5/3/05 - SEA - 50
5/3/05 - AIR - 1
5/3/05 - DIRECT - 5
5/3/05 - AIR - 1


I need to have an automatic daily total of AIR=2 / SEA=100 / DIRECT=5


Now, there can be multiple Sea/Air?directs on the same date. I need a daily total of P/N shipped per each kind of shipment.

Is there a function that can look at the criteria of date, look for a second colum with the SEA/AIR/DIRECT and finally add up the total number of # numbers for the indicated Sea/Air/Direct?

Does this make sense?

[Alex Delamain]

Try the following:

=SUMPRODUCT((A1:A100=F1)*(B1:B100=F2)*(C1:C100))

I have put the date to analyse in cell F1 and F2 is where you specify Air, Sea etc