I know this is probally a very easy thing but I can seem to figure it out of find a reference for this I would like to take this type for formula and simplify it
=PRODUCT(A2:A3)+PRODUCT(C2:C3)+PRODUCT(D2:D3) etc etc
is there a way to use a range to do this without entering each individual calculation as I have several dozen to do at least?
Maybe: =SUMPRODUCT(A2:D2*A3:D3)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Yes indeed thank so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks