RE: Sales Report Grrrr
- From: JMB <JMB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 31 Jul 2005 20:33:02 -0700
As an example, let's say your data is in cells A1:D4.
You could create a table with month number along the left side and names
across the top (in my test I created this table in cells A10:C14)
John Matt
1 X
2
3
4
5
6
Then enter a formula like this, copy across and down (I entered it in cell
B11, where the "X" is above):
=SUMPRODUCT((MONTH($A$1:$A$4)=$A13)*($C$1:$C$4=B$10)*($B$1:$B$4="Bike"))
To get the value of the bikes sold, you could add
*($D$1:$D$4)
at the end of the formula (inside the last parenthesis).
"jshafer817" wrote:
>
> I need some major help. I have 4 columns.
> A B C
> D
> 3/1/2005 Bike John
> Amount
>
> a is date
> b is product
> c is salesman
> d is amount
>
> I need to write a formula and come up with a chart that will show how
> many bikes that john sold, each month.
>
> I thought it would be a lot simpler, and I am trying to educate
> myself.
> I have played with SumIF and SumProduct, but I dont think sumif
> supports multiple criteria ranges.
>
> I am a major noob when it comes to writing formulas. I could build you
> a samba server, and build a website, but I cant seem to do this at
> all.
>
> I bet this is easy for some of you guys out there. Can you lend me a
> hand????
>
>
> --
> jshafer817
> ------------------------------------------------------------------------
> jshafer817's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25758
> View this thread: http://www.excelforum.com/showthread.php?threadid=391707
>
>
.
- References:
- Sales Report Grrrr
- From: jshafer817
- Sales Report Grrrr
- Prev by Date: Re: How to calculate hours?
- Next by Date: Re: Sales Report Grrrr
- Previous by thread: Re: Sales Report Grrrr
- Next by thread: Re: Sales Report Grrrr
- Index(es):
Relevant Pages
|
