M
MathewS
I need to use a date range from a date column as on of two
criterium for a Sum function, using an array.
example:
A - dates (one criteria)
B - quantity (second criteria)
C - price (column to sum, if both criterium are met)
my array formula so far:
=SUM((A12:A55>=1/1/2002)*(A12:A55<=1/31/2002)*(B12:B55)*
(C12:C55))
criterium for a Sum function, using an array.
example:
A - dates (one criteria)
B - quantity (second criteria)
C - price (column to sum, if both criterium are met)
my array formula so far:
=SUM((A12:A55>=1/1/2002)*(A12:A55<=1/31/2002)*(B12:B55)*
(C12:C55))