hi,
could you please look at the attached file
column a and b and row 14 and 15 could be a lot longer
and as you can see thwe formular in l15 could be a lot longer
is there an easier way to do this.
thank you
steve
hi,
could you please look at the attached file
column a and b and row 14 and 15 could be a lot longer
and as you can see thwe formular in l15 could be a lot longer
is there an easier way to do this.
thank you
steve
Why dont you do it like this, and just insert rows and copy the formula
down (by dragging with your mouse) ?
Does this help you ?
Try this array (Ctrl + Shift + enter)
=SUMPRODUCT(--(B4:B11)*(TRANSPOSE(D15:K15)))
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
thanks
steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks