LinkBack URL
About LinkBacks
IS there a way to apply sums to bold entries?
or alternatively, have them sum up only if the column next to them have PAID in them or equivalent?
IS there a way to apply sums to bold entries?
or alternatively, have them sum up only if the column next to them have PAID in them or equivalent?
SUMIF function can sum cells that have PAID in a separate column
Here's a link to a User Defined Function to count only bold cells in a range you specify:
http://www.mcgimpsey.com/excel/udfs/sumbold.html
After putting this code into a module in your workbook, you can then use the formula:
=SUMBOLD(your_range)
For example:
=SUMBOLD(A1:A20)
Good morning Ivalaine
Alternatively, download and install my add-in via the link below.
Go to Ultimate > Formulae > Add Function
Select SumFontProperties, and click OK
Then use this formulae
=SumFontProperties("Fontstyle","Bold",A1:A5)
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
See previous thread also
http://www.excelforum.com/showthread.php?t=600739
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks