jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 384
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
hi
i have in:
B1=5
B2=300
C1=3
C2=200
E1=1
E2=100
in the cell: A2 i need the multiplication of row 1 with row 2, and sum it, the result is: 1500+600+100 = 2200
i know... if in the third row multiply b1*b2 and then sum i get the result. but not like me the way.
see image: Pasteboard - Uploaded Image
thanks
i have in:
B1=5
B2=300
C1=3
C2=200
E1=1
E2=100
in the cell: A2 i need the multiplication of row 1 with row 2, and sum it, the result is: 1500+600+100 = 2200
i know... if in the third row multiply b1*b2 and then sum i get the result. but not like me the way.
see image: Pasteboard - Uploaded Image
thanks