Hi,

In my project i had at first two columns for each year, but things went a little too big. Now my currently last year is the EQ column, and i prefer it that way.

However, counting everything was easier with two columns. Since i have one column for each year, i don't know how to sum things.

Example:

Before i had two rows with, let's say,

1950 --- 1951
30|12 --- 26|10 Etc. > A2=56 B2=22

So since now i have one column for each year,

1950 --- 1951
30-12 --- 26-10 (or 30~12) (26~10) as long as the numbers are split for better understanding.

How do i sum in A2 ALL left side numbers and in B2 ALL right side numbers?

I tried sumproduct (left ~:~) but i got zero...

Thanks.