Hi,
Is there's any way to calculate 2 cells separate with comma,
attached is the detail. thank you very much.
Value1 are variable: 0,0,3,6,4,2,0,0,0,0
Value2 are fix: 5,15,25,35,45,55,65,75,85,95
i want to multiply those 2 cells:
=SUM((0*5),(0*15),(3*25),(6*35),(4*45),(2*55),(0*65),(0*75),(0*85),(0*95))
BR//
Bookmarks