Hi,,
I was hoping for some guidance or help on this matter, I have a sheet with data like the attachment below, but across 1145 lines: -
I've done the first part of what I want to do which was count the number of individual Pensions, Investment, Protection cases using COUNTIFS(A:A,"George Chantry",B:B,"Pension")
My next step is to add up the amount received in Pension, Investment, Protection, so the example would output Pension £1500, Investment £3500, Protection £1000 when accumulated together,,
I cannot think of a formula that would give me the results I need, maybe some sort of IF A:A = G CHANTRY AND B:B = PENSION THEN ADD C,,or something to this effect,,
Hope I've made this clear,
Any help would be much appreciated,
Regards,
KJMOSP
Bookmarks