need formula

Giganews Newsgroups
Subject: need formula
Posted by:  geo (gcang…@sympatico.ca)
Date: Tue, 28 Oct 2003

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

Replies