I HAVE A LARGE SHEET COLUMNS RANGING FROM D TO WV.
I WANT TO SUM EVERY OTHER COLUMNS. PLS HELP ME
THANKS
Then the desired result should be
=SUMPRODUCT(D1:WV1, D7:WV7)
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 295 |
Nodes: | 16 (3 / 13) |
Uptime: | 09:27:58 |
Calls: | 6,644 |
Calls today: | 4 |
Files: | 12,190 |
Messages: | 5,326,334 |