Questions

Answer for:

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

Message 5 of 8

View entire thread
+
0 Votes
Charles Bundy

The code works as advertised under Excel 2010.

If that is the version of excel you are using hit [ALT][F11] to get to the VBA editor the select Module from the Insert menu. Type the code in, flip back to your worksheet and assuming you have values in A & C you should be able to go to an empty cell and type =sumBoldCells(C1:C45). The only caveat is no auto refresh. That will be left as an exercise for the student...