Sum formulas and none formulas

**Nighteg** · 07-01-2013, 08:31 AM

Hi.
I have a list of names. Some of them are text, others are formulas (hyperlinks, in blue).
I need the sums of the numbers in column B for regulars, and for the hyperlinked.
What's the quickest way to do it?
Thanks!
Sample.xlsx

**Debraj Roy** · 07-01-2013, 08:34 AM

Hi Nighteg..

None of your Look-A-Like HYLERLINK cells are actual LINK..

Do you want sum according to FontColor & Underline..
Or sum according to Link & Non-Link Text..

**Nighteg** · 07-01-2013, 08:49 AM

Hi Debraj.
In my workbook they are

So please sum according to Link and non-link.
Thanks.

**Debraj Roy** · 07-01-2013, 09:02 AM

Hi Nighteg..

try this..

Please Login or Register  to view this content.

In the meanwhile.. trying to figure out if possible through FORMULA, or NamedRange or Get.CELL..

**Nighteg** · 07-01-2013, 09:44 AM

Thanks a lot, but i need it with a formula. I have lots of tabs like these, and the range varies from 10, to over 200, and changes every month. I'd have to edit the macro for each one of them

**Debraj Roy** · 07-01-2013, 11:40 AM

If you can upload a sample file, then I can help to create a macro for the same..

**Nighteg** · 07-01-2013, 01:26 PM

Let's try it this way: is there any formula in excel that checks if a cell contains a formula (and gives true or false)?
p.s. i've uploaded a sample with the hyperlinks.