Sales Report Grrrr


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

.

Relevant Pages

  • RE: Sales Report Grrrr
    ... let's say your data is in cells A1:D4. ... > I need some major help. ... > d is amount ... > I have played with SumIF and SumProduct, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Rounding issues
    ... I have to tally the total amount ... That's what the SUMIF formula is ... >them in my SUMIF formula, or what to replace that formula ... you may introduce errors in the totals. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do you add related cells in a sum?
    ... Check HELP (if your version still has a decent HELP) for SUMIF ... If the type is "Check" then I want it to add the amount in the sum "Total Checks." ... How do I tell it to add all of the related amount cells for "Checks," but not ALL of the cells with amounts? ...
    (microsoft.public.excel.misc)
  • Re: Sum problem
    ... Couldn't you use SumIf instead of Vlookup? ... you can sum an #N/A-ridden range with SumIf: ... > I'm using a VLOOKUP formula to find an amount of money won from the ...
    (microsoft.public.excel.worksheet.functions)
  • nested sumif
    ... I need to sumif into a cell based on two columns' ... I want to sum the amount if it is a certain date, ... Date Test1 Test2 ...
    (microsoft.public.excel.misc)
Loading