Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum A1*B1 through to A12*B12 in one easy forumla?
Try: =SUMPRODUCT(A1:A12,B1:B12)
"holly" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum A1*B1 through to A12*B12 in one easy forumla?
Looks like:
=SUMPRODUCT(A1:A12,B1:B12) holly wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum A1*B1 through to A12*B12 in one easy forumla?
See if one of these works for you
This one uses only A1:B12 =SUMPRODUCT(A1:A12,B1:B12) or This one just includes a larger range than you need =SUMPRODUCT(A1:A100,B1:B100) or This one automatically adjusts to additional data (no blanks, though) =SUMPRODUCT($A$1:INDEX($A:$A,MAX(COUNT(A:A),COUNT( B:B))),$B$1:INDEX($B:$B,MAX(COUNT(A:A),COUNT(B:B)) )) or This one allows for blanks between the number entries and uses the range that includes the last numeric entry in Cols A or B =SUMPRODUCT($A$1:INDEX($A:$A,MAX(MATCH(10^99,A:A), MATCH(10^99,B:B))),$B$1:INDEX($B:$B,MAX(MATCH(10^9 9,A:A),MATCH(10^99,B:B)))) Does that help? *********** Regards, Ron XL2002, WinXP "holly" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy question? Page numbers | Excel Discussion (Misc queries) | |||
HELP!!! Can't get forumla figured out! | Excel Discussion (Misc queries) | |||
test forumla rather than result | Excel Worksheet Functions | |||
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel |