Hi

Have looked on treads and have got the following which works great

=sumproduct(--(A1:a10="test"),--(b1:b10="test1"))

But when I substitute the real requirement from the file, GA01 and 105
respectively, I get 0.

The file is a .CSV, what ever that is, which is generated from a VTMS- AS400.

Does anyone know a way around this problem?

Regards

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1