Re: Sales Report Grrrr

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


=sumproduct((datevalue(daterange)>=datevalue(x))*(datevalue(daterange)<=datevalue(y))*(salesmanrange="john")*(productrange="apple")*(amountrange))

where daterange is the column of dates, salesmanrange is the columnof
salesmen, productrange is the column of products, and amountrange is
the column of amounts. All are defined ranges such as a2:a100, not
a:a.


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11624
View this thread: http://www.excelforum.com/showthread.php?threadid=391707

.