John Wrote:
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

Hi John

Try this =IF(AND(A1="X",A2="X"),SUM((B1*C1)+(B2*C2)),"")


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=475995