SumProduct
 

I Have a calculation I wish to carry out, it is based on 6 columns, I would
like to carry out the following

Col A = 1
Col B = 1
Col C = 1

If So Add Contents of Col D & E together and return the value,

Im Lookin gfo it to do this wherever the above criteria applies within the
main spreadsheet.

Any Help would be gratefully accepted

Regards

JR

SumProduct
 

=IF(COUNTIF(A2:C2,1)=3,D2+E2,"")

--
__________________________________
HTH

Bob

"LakeDistrict Man" <LakeDistrict wrote in
message ...
I Have a calculation I wish to carry out, it is based on 6 columns, I would
like to carry out the following

Col A = 1
Col B = 1
Col C = 1

If So Add Contents of Col D & E together and return the value,

Im Lookin gfo it to do this wherever the above criteria applies within the
main spreadsheet.

Any Help would be gratefully accepted

Regards

JR

SumProduct
 

Hi,

If you want to do the entire range in one formula try this

=SUMPRODUCT((A1:A1000=1)*(B1:B1000=1)*(C1:C1000=1) *(D1:D1000+E1:E1000))

If you want it row by row use this dragged down
=IF(AND(A1=1,B1=1,C1=1),D1+E1,"")

Mike

"LakeDistrict Man" wrote:

I Have a calculation I wish to carry out, it is based on 6 columns, I would
like to carry out the following

Col A = 1
Col B = 1
Col C = 1

If So Add Contents of Col D & E together and return the value,

Im Lookin gfo it to do this wherever the above criteria applies within the
main spreadsheet.

Any Help would be gratefully accepted

Regards

JR