And so says Bob too <vbg

Seriously John, I did test it so as Roger says, it is probably data
problems. Cut the data down to a few lines and test it, increasing it bit by
bit until you get an error. That will point you closer to the error.

Bob
(remove nothere from email address if mailing direct)

"Roger Govier" wrote in message
...
Hi John

Bob's formula is correct and works fine. It returns 110 for the two rows
of data you show.
There must be something wrong with your data. Numbers entered as Text?
Spaces before or after entries?

Regards

Roger Govier



John wrote:

Thanks for your reply Bob....But it was not working ....It was returning
a
#value ....Can you please try with some examples and see why it was wrong

"Bob Phillips" wrote:



=sumproduct(--(A1:A4="X"),B1:B4*c1:C4)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...


I have a question with IF and SUMIF stuff... In my situation i have
Text


data


in Column from A1:A4....Have Numerical data in Column from B1:B4 and
from
C1:C4....then i need a formula in D1(Any single cell)which will do this


i.e.


" If in column A1:A4 Is "X" then Multiply the Corresponding cells in
(B1:B4)*(C1:C4) and sum the total of each single row at our D1.

For Ex:
1st Row = Cell A1 = "X" ; Cell B1 = 3 ; Cell C1 = 20
2nd Row = Cell A2: "X" ; Cell B2 = 5 ; Cell C2 = 10

Then in a single cell we should have a condition which will check to
see


if


we have "X" if that is true then it will multiply the corresponding B1
*


C1


In our Case at Cell D1 = If( A1:A2 = "X" then do (B1*C1) + ( B2*C2)

It's been a while that i am fighting with this...I will be thankful if
someone can help me with this