count 2 criteria text or numbers
Are you putting the 105 inside the quotes of test1 ?
If you have numbers in column B of your file, then you should not use
quotes.
Hope this helps.
Pete
On Nov 20, 7:05 pm, "BNT1 via OfficeKB.com" <u19326@uwe wrote:
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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1
|