Sum of values based on different criteria
Try this:
E1 = terminated
F1 = HB
=SUMPRODUCT(--(A1:A5=E1),--(B1:B5=F1),C1:C5)
--
Biff
Microsoft Excel MVP
"Irene" wrote in message
...
I have a column (lets say column A) that has a dropped down list of
'terminated' or 'completed' (let say from row 1 to row 5), and I have
another
column (Column B) that I enter a code of 'HB' for home buying (there are
blank cells); then my last column (column C) has an amount. Now, I would
like to know how much is the total (sum) for the terminated and the total
for
completed.
Any help will be appreciated.
Thanks
|