Questions

Answer for:

if statement microsoft excel- if column a has bold text then sum column c

Message 4 of 8

View entire thread
+
0 Votes
cliffbeacham

While you can do this with VBA I would just use a SUMIFS() and a helper column (it is a lot simpler). Put a 1 in the helper column next to the required amounts and then 'sum' the amts using SUMIFS(). This has the advantage that you can use the technique at any time (you don't have to have your code available) using a built-in Excel formula. Also you can have more than 1 group because you are not just using a True/False (only 2 outcomes). Also you do not have to alter the formating (although you could).