Multiple Criteria and Adding Them Together

[p_h_i_b_e_r]

I have a multiple column worksheet and I am trying to setup a formula or
function that will take the date and total the number of sales for that
day and then also break them down into 3 catagories. The only thing I
need help on is the first formula and then the rest is just swapping
out the category name in the search... Let me show you guys the setup
of the worksheet.


___A_______B_______C_______D_______E_______F___
__DATE____NAME___PHONE___ESN D___ESN H___PLAN__
_09/07/04________________________________Post Pay_



Can someone please help me...

Thanks

 

[Don Guillett]

something like this where a1 contains the date. ranges must be the same
size.
=sumproduct((daterange=a1)*(categoryrange="cat1")*salesrange)

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[p_h_i_b_e_r]

Is there the ability to do this by breaking it down for the individua
day of the month

Frank I went to the website that you posted and it is great informatio
but I think I am just over-seeing that part.. Thanks for your help...

I have never tried this command before so I am trying to learn it...
Thanks agai

 

[Frank Kabel]

Hi
not really sure about your data. Could you explain in plain text what
you're trying to add. e.g. add column B where column a conatins the
value y....

 

[p_h_i_b_e_r]

What I am trying to do is setup a worksheet that in Column A has th
date setup 09/07/2004 and then in column F it states 3 differen
possiblities like Post Pay, Clear Pay, or Chat Pak.. What I am tryin
to do is seperate per day what was sold.. If we sold 3 post pay and
chat pak on 09/07/2004 then it will put that in the proper section o
my additional worksheet

 

[Don Guillett]

Did you see my post? where a1 contains the date you want
=sumproduct((a2:a22=a1)*(f2:f22="Post Pay")) to count them
=sumproduct((a2:a22=a1)*(f2:f22="Post Pay")*c2:c22) to sum if sales in col C