SUMIF FUNCTION WITH MUTIPLE CRITERIA
Posted by WILLIAM OKUMU on January 16, 2002 5:57 AM
AM TRYING TO WRITE A FORMULAE THAT WILL BE ABLE TO SUMMARISE THE TOTAL OF STOCK CODE QUANTITY USING THE STOCKCODE AS ONE OF THE CRITERIA AND THIS QUANTITY HAVING BEEN DELIVERED ON DIFFERENT DATES THEIR BY HAVING DATE AS ANOTHER CRITERIA
Posted by Aladin Akyurek on January 16, 2002 6:12 AM
Multiconditional Sum
=SUMPRODUCT(($A$2:$A$10=E1)*($B$2:$B$10=E2),($C$2:$C$10))
where A2:A10 houses the stockcodes, B2:B10 the dates, C2:C10 the quantity, E1 a criterion stockcode, and E2 a criterion date.
The date criterion can be an interval of From and To, which will require extending the formula to cover the date interval condition.
Aladin
=======
