A Anil Sevak New Member Aug 5, 2017 #1 HI, I want to to diagnoal summation in range of number in excel. I got formula form the google. but can anybody give me simple formula or VB Code for the same. Attachments Diagnoal Summation.xlsx 8.7 KB · Views: 7
HI, I want to to diagnoal summation in range of number in excel. I got formula form the google. but can anybody give me simple formula or VB Code for the same.
R rahulshewale1 Active Member Aug 5, 2017 #2 HIII, is this you looking for ? {=SUMPRODUCT((ROW($B$3:$K$12)-MAX(ROW(B3:K12))=COLUMN($B$3:$K$12)-MAX(COLUMN(B3:K12)))*($B$3:$K$12))} use ctrl +shift +enter Thanks rahul shewale Attachments Diagnoal Summation.xlsx 13.9 KB · Views: 5
HIII, is this you looking for ? {=SUMPRODUCT((ROW($B$3:$K$12)-MAX(ROW(B3:K12))=COLUMN($B$3:$K$12)-MAX(COLUMN(B3:K12)))*($B$3:$K$12))} use ctrl +shift +enter Thanks rahul shewale
