Thread
:
SumProduct
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
Posts: 2,420
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
Reply With Quote
Bob Phillips[_3_]
View Public Profile
Find all posts by Bob Phillips[_3_]