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

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

Pete

Thats brilliant, the quotation marks were the sticking point, all working
fine
by the way, not sure if this should this be entered Ctl+Shift+Enter? it
working ok

thanks again

Pete_UK wrote:
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

Hi

[quoted text clipped - 15 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1

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

Glad to hear that it worked - thanks for feeding back.

Although SUMPRODUCT acts upon arrays, it does not (generally) need to
be committed with CTRL-SHIFT-ENTER.

Pete

On Nov 20, 7:40 pm, "BNT1 via OfficeKB.com" <u19326@uwe wrote:
Pete

Thats brilliant, the quotation marks were the sticking point, all working
fine
by the way, not sure if this should this be entered Ctl+Shift+Enter? it
working ok

thanks again

Pete_UK wrote:
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

Hi

[quoted text clipped - 15 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1