Putting another criteria within a sumif statement

  • Thread starter Thread starter Rhino
  • Start date Start date
R

Rhino

I am trying to do a sum if statement with an additional
criteria and it isn't working!!

DBK Opus Femur Progress.xls

Column B is a product code,
Column D is the Qty for that relevant order
Column P is the date is meant to be finished by.

Cell A4 the first criteria that needs to be used. (In
column B)

The second criteria is if Column P is greater than 1st
November 2003(01/11/2003)and less than 30th November
(30/11/2003), then give me the sum of that criteria from
column D. I've for the sum if statement, but don't know
how to put the date requirement in.

What I have is beloew

=SUMIF('[DBK Opus Femur PROGRESS.xls]Sheet1'!
$B$4:$P$128,A4,'[DBK Opus Femur PROGRESS.xls]Sheet1'!
$D$4:$D$128)
 
try modification of this idea to suit.
=sumproduct((rngA="productcode")*(rngB="whaterver")*rngC)
 
Back
Top