Help!!! I only have until Monday.

  • Thread starter Thread starter snix
  • Start date Start date
S

snix

A B C
Peter 3 1.73
Mike 6 2.00
John 5 2.81
Peter 3 0.76
John 2 1.2
Jane 1 1.4
Peter 4 3.20

Where I'd like to get to is in the above example, total the value in column
B where "Peter" has a value in column C of >=2.06. So that should total 6 in
the above example.

I'm desperate.

snix
 
Actually, the answer is 4 for your example:

=SUMPRODUCT((A1:A7="Peter")*(C1:C7>=2.06)*B1:B7)

HTH
Jason
Atlanta, GA
 
Try SUMPRODUCT in a cell in say, Sheet2:

=SUMPRODUCT((Sheet1!A1:A7="Peter")*(Sheet1!C1:C7>=2.06)*(Sheet1!B1:B7))

Note that the ranges (A1:A7, C1:C7, etc) must be identical
and entire columns (A:A, C:C) cannot be used in SUMPRODUCT

The above will return a total of "4"
(not "6" as mentioned in your post .. unless you mean
... where "Peter" has a value in column C of <=2.06)
 
Back
Top