need formula

[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

 

[Arvi Laanemets]

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

 

[Alan]

=((SUMPRODUCT(A1:A100="March")*(C1:C100))

 

[Andy B]

Hi

Look at Data/Pivot Table. This is designed to summarize data.

Andy.