• 460K Members
• 11.4K Online
• 557K Conversations

## Conditional Formatting Sum Help

Occasional Visitor

# Conditional Formatting Sum Help

Hello!

I am currently working on a project in which I will need to calculate the sum of each column, based off the conditional format color. I have tried everything to using the conditional formatting formulas as just a regular sum formula, as well as even looking up macros to use.

However, all the macros I found were for the whole set of data, calculating the sum of the whole data for each conditional color. However, I am looking to calculate each conditional color per column. Any help would be greatly appreciated

# Re: Conditional Formatting Sum Help

Hello @Jordan93

The conditions from the conditional formulas can be used almost verbatim as conditions in a Sumproduct statement.

Try this for green in B1419 =SUMPRODUCT(B\$5:B\$1414*(B\$4-A\$5:A\$1414<=45))

for yellow in B1420 =SUMPRODUCT(B\$5:B\$1414*(B\$4-A\$5:A\$1414>45)*(B\$4-A\$5:A\$1414<=90))

for orange in B1421 =SUMPRODUCT(B\$5:B\$1414*(B\$4-A\$5:A\$1414>90))

Then copy across the other columns.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies