Thread: SumProduct
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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