Converting formula from open office

[MrSpud]

Have purchased excel again recently.
Cannot convert 2 formulas from open office.
1st is
=SUMPRODUCTS(S14:S7409=06;T14:T7409=Q6:X14:X7409=R6;Y14:Y7409)

Any help please

 

[Aladin Akyurek]

Care to post the formulas exactly as you have each in Open Office?

 

[MrSpud]

Care to post the formulas exactly as you have each in Open Office?

I nearly have answer
=SUMPRODUCTS(S14:S7409=06),(T14:T7409=Q6),(X14:X7409=R6) THIS PART DUNNO Y14:Y7409)
Brackets and commas but the return answer part im stuck

 

[Aladin Akyurek]

I nearly have answer
=SUMPRODUCTS(S14:S7409=06),(T14:T7409=Q6),(X14:X7409=R6) THIS PART DUNNO Y14:Y7409)
Brackets and commas but the return answer part im stuck

Why don't you post those formulas from Open Office as asked for?

 

[MrSpud]

Why don't you post those formulas from Open Office as asked for?

The open office formula is in opening post

 

[Aladin Akyurek]

The open office formula is in opening post

1. As far as I know there is no function called SUMPRODUCTS. Apache OpenOffice 4.1.2 does not contain such a function. Is that different in your version of OpenOffice?

2. You are talking about two formulas. I don't see two formulas: just one, one which seems to be ill-formulated.

 

[MrSpud]

1. As far as i know there is no function called sumproducts. Apache openoffice 4.1.2 does not contain such a function. Is that different in your version of openoffice?

2. You are talking about two formulas. I don't see two formulas: Just one, one which seems to be ill-formulated.

=sumproduct(s14:s7409=06),(t14:t7409=q6),(x14:x7409=r6) this part dunno y14:y7409)

 

[mohan.r1980]

Try

=SUMPRODUCT(--(S14:S7409="06"),--(T14:T7409=Q6),--(X14:X7409=R6))

 

[Aladin Akyurek]

=sumproduct(s14:s7409=06),(t14:t7409=q6),(x14:x7409=r6) this part dunno y14:y7409)

May I ask why you refuse to post the formula you have in OpenOffice as is from OpenOffice itself?