New and need help, please

R

retcgr

Gosh I'm glad I found this site! I'm about to yank my hair out! :eek:

Because my spreadsheet is so big, I've gotten myself confused.
Basically, I'm trying to multiply and add between rows and columns.
Ex: (B2*B102)+(C2*C102) across to (CG2*CG102). I've got that lon
string in a single cell but it's not working. There is data in th
rows that the formula is supposed to read, but it's still giving m
zilch. There must be an easier way! Any suggestions? Thanks i
advance
 
B

Bob Phillips

TRy

=SUMPRODUCT(B2:CG2,B102:CG102)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top