OK, nobody seems to know the answer to my question this morning and I reckon I've overcomplicated things. What I want to do now instead is calculate the sum of values in column B, depending on the values in column A.
Example:
Col a Col b
a 25
a 45
a 65
b 70
c 50
a 15
b 20
A function (DSUM?) would calculate the total for everything with an 'a' in column a.
Can anybody help?
Bookmarks