Summing highlighted cells only

**theshark43** · 07-06-2011, 03:27 PM

Is there a formula that will SUM only the highlighted cells in a column?

See attachment as an example

For example, in column 1 through 3, i only want the sum of the contents in yellow to show up?

Any help is appreciated.

Thanks

**stanleydgromjr** · 07-06-2011, 04:00 PM

theshark43,

Your workbook Project is password protected.

Detach/open workbook Sum Count by Color - theshark43 - EF783094 - SDG13.xlsm and check the formula/Function in cells H1, H2.

**stupid818** · 05-25-2015, 10:43 PM

I have similar question and read the answer above. However, when I try to set same formula in original spreadsheet sent from requestor, answer came out is "#NAME". Can anyone help on resolving it?

Thanks

**protonLeah** · 05-25-2015, 10:52 PM

@stupid818,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**acroley1** · 05-25-2015, 10:52 PM

If you don't want to use VBA, a countif might work but you'd have to share more detail on why the cells are colored yellow.

**protonLeah** · 05-25-2015, 11:35 PM

acroley1,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.