Look at this:
http://www.lqnet.com/Excel/sumproduct.aspx
Pay attention to these examples:
=SUMPRODUCT((A2:A5="Chicago")*(B2:B5="ABC")*(C2:C5 ))
=SUMPRODUCT((A2:A5="Chicago")*(B2:B5="ABC")*(C2:C5 ="Jan:), (D2:D5), (E2:E5))
Here's a video with a few more examples:
http://www.youtube.com/watch?v=O2ulQwMmlmY
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"PAL" wrote:
I am using the COUNTIF function as follows.
=COUNTIF(Data!AN2:AN533,LOV!A2)
It works for the most part, however, the fields I am looking up
(Data!AN2:AN533) may have more than one value in it.
That is, if LOV!A2 is "Car", Data!AN2, may have "Car, Train,..." or "Train,
Car...).
Is there anyway to use Countif and a wild card value?
Thanks. Happy Holidays.