If criteria match multiply one cell with the cell right next to one of the matched criteri

[Luther.King]

Hot to refer to the right next cell in this formula?



=COUNTIF(Orders!A:A;A5)*( the cell to the right of the refered cell )


Means, multiply with the values on the cell at the right of A5 match cells.

[ChemistB]

Sounds like you want to use SUMPRODUCT

=SUMPRODUCT(--(Orders!A:A=A5), A5*Orders!B:B)

Does that work for you?

[Jonmo1]

=COUNTIF(Orders!A:A;A5)*( the cell to the right of the refered cell )


Means, multiply with the values on the cell at the right of A5 match cells.

Would that be
=COUNTIF(Orders!A:A;A5)*(B5)

[Luther.King]

No because it's multiplying by 10, which is the value on Orders!B5 and for example on Orders!B8 i have again the referred COUNTIF A5 but now 5 items and the result it's 20, not 15.

[Jonmo1]

Try
=SUMIF(Orders!A:A;A5;Orders!B:B)

[Luther.King]

"The formula you type contains an error"

[Jonmo1]

Refresh your browser, I edited it to change a comma to a semicolon

[ChemistB]

Did you try my formula

=SUMPRODUCT(--(Orders!A:A=A5); A5*Orders!B:B)
?
Can you upload an example of what you have and what you want result to be? (Go Advanced > Manage Attachments)

[Luther.King]

Thank's Jonmo1, worked.

I have another problem to solve, can i post it here or do i have to open another topic?

[Jonmo1]

You're welcome

I'd say go for another thread

[Luther.King]

Ok, i'll open a new one.

Once again thank's for help.

[Luther.King]

Hi Jonmo1.

I posted my workbooks on this new thread.

Can you take a look and tell me is it's possible to do what i intend to?

Thank's in advance.


http://www.excelforum.com/excel-form...t=#post3635967