Search for multiple criteria, and return yet another
=SUMPRODUCT(--(A1:A100="Jones"),--(D1:D100="baseball"),E1:E100)
Not sure I understand the '--' before the arguments. Can you clarify?
--
JMG
"PCLIVE" wrote:
=SUMPRODUCT(--(A1:A100="Jones"),--(D1:D100="baseball"),E1:E100)
or if Name is in AA1
and EventName is in AB1
=SUMPRODUCT(--(A1:A100=AA1),--(D1:D100=AB1),E1:E100)
HTH,
Paul
--
"JMG" wrote in message
...
Basic output from 3rd party database is .xls in a format similar to:
Name OtherData OtherData EventName PointsEarned
Jones xxxxx xxxxx baseball 2.0
Jones xxxxx xxxxx football 2.5
Jones xxxxx xxxxx soccer 3.0
Smith xxxxx xxxxx baseball 1.0
Smith xxxxx xxxxx football 1.1
Smith xxxxx xxxxx soccer 1.5
White...and so on
My Goal:
Lookup by Name and EventName, and return PointsEarned.
BASEBALL FOOTBALL SOCCER
Jones 2.0 2.5 3.0
Smith 1.0 1.1 1.5
White...
I also totally lack understanding of PivotTables, and out of pure
stubbornness, am trying to avoid using them. ...probably to my own
demise.
Thanks in advance.
--
JMG
|