Array Formula

  • Thread starter Thread starter ak
  • Start date Start date
A

ak

I'm trying to compare 2 fields and sum a third.

Current layout:
Column A Column B Column C
John 80 Jan-03
Mary 65 Feb-03
John 64 May-03
John 50 Feb-03

What I'm trying to do is calculate by name and date a
total score.

So I would do a search on "John" in Column A, sum all
scores if prior to March - 03 would bring back a value of
130.

I tried using the SUM function in an array, but I'm not
sure how to sum the values in column B.


Thanks
AK
 
AK

=SUMPRODUCT((A3:A6="John")*(C3:C6<DATEVALUE("Mar 3"))*(B3:B6))

Not an array formula.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Back
Top