Sum by Color | Excel University

If you need to compute the total for certain cells based on their font or fill color, you may have noticed that Excel formulas operate on stored values, not displayed values. That means that functions such as SUM and SUMIFS operate on the underlying cell values and disregard cell formatting, such as font or fill…

Source: Sum by Color | Excel University

Advertisements

About HDA Consulting, LLC

HDA Consulting LLC provides a variety of accounting services including; forensic & litigation consulting, fraud & embezzlement investigation, payroll & tax. http://hdaconsultingllc.net. Try TSheets https://www.tsheets.com/#a:hdaconsulting
This entry was posted in Excel, save time, Spreadsheets, Training and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s