Hi.
Bit of a newbie to Excel, so would appreciate some help with a couple of formula's, I think using "COUNTIF"
In column C2:C100 I have either A, B or C, and in column L2:L100 I have different amounts of money.
How would I add the corresponding figures up?
For example:
If C2, C6, C7, C12 was "A" and L2 was £2, L6 was £3.50, L7 was £2.88 and L12 was £4.12
Then if C3 and C4 was "B" and L3 was £5 and L4 was £3
I hope that explains what I'm after. Basically I want to add up all the A's, B's and C's.
Bookmarks