need formula

  • Thread starter Thread starter geo
  • Start date Start date
G

geo

Example: Column A1 to A100 there are months from January to December in
random quantities. In column B1 to B100 there are persons names, in column
C1 to C100 there are values (commissions).

I need a formula to sums in 2 criteria's such as. If A1 to A100 there is
March how much commission (column C1 to C100) in selected names



Thank-you in advance
 
Hi

=SUMPRODUCT(($A$1:$A$100="March")*($B$1:$B$100="John")*($C$1:$C$100))
or
=SUMPRODUCT(($A$1:$A$100=3)*($B$1:$B$100="John")*($C$1:$C$100))
or
=SUMPRODUCT((MONTH($A$1:$A$100)=3)*($B$1:$B$100="John")*($C$1:$C$100))
depending how you have stored the month in column A. And of course you can
have cell references instead "March" and/or "John".


Arvi Laanemets
 
Back
Top