ExcelBanter - sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumproduct (https://www.excelbanter.com/excel-worksheet-functions/195656-sumproduct.html)

vlook fomula

sumproduct

i have different data in different column and i want to calculate the
alternate cell/column then how i can apply this

regards
Zafar

Bob Phillips[_3_]

sumproduct

=SUMPRODUCT(--(MOD(COLUMN(A2:M2)-COLUMN(A2),2)=0),A2:M2)

--
__________________________________
HTH

Bob

"vlook fomula" wrote in message
...
i have different data in different column and i want to calculate the
alternate cell/column then how i can apply this

regards
Zafar

All times are GMT +1. The time now is 02:08 PM.