how do i sum A1*B1 through to A12*B12 in one easy forumla?
i know i have done an easy formula in the past where i can add new rows and
not have to re-do the forumla to sum an example like a1*b1 through to
a12*b12. does anyone remember how to do this without having to ancor colum a
row by row?
|