Sum if and statement

[Susan]

i am trying to put together a formula that sums a column based on the
information in two other columns. The two columns that need to be evaluated
have Dept name and Customer name. there are approximately 80 rows that need
to be evaluated in each column, and i want the sum to be only of the values
that match the criteria for the Dept & Customer names.

 

[John C]

assuming your data is in cells A2:C100, Dept Name is col A, Cust Name is col
B, and value to sum is col C.

=SUMPRODUCT(--($A$2:$A$100=deptname),--($B$2:$B$100=custname),($C$2:$C$100))

Hope this helps.