I've got a problem, here is an example of the issue:
Cell A1:A3 value = 40
Cell B1:B3 Value = 100
Cell C1:C3 Value = 140
Cells D1 & D2 are SUM cells which add up the values.
I'm trying to find a way for D1 to SUM all the 40's
D2 to Sum all the 100's
Also i'm looking for a way to...