Home

Excel, I need help with a formula that adds cells in a range that do not have a fill color

%3CLINGO-SUB%20id%3D%22lingo-sub-847432%22%20slang%3D%22en-US%22%3EExcel%2C%20I%20need%20help%20with%20a%20formula%20that%20adds%20cells%20in%20a%20range%20that%20do%20not%20have%20a%20fill%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847432%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20formula%20that%20adds%20cells%20in%20a%20range%20that%20do%20not%20have%20a%20fill%20color%2C%20As%20things%20are%20getting%20paid%20i'm%20filling%20in%20the%20boxes%20with%20the%20color%20and%20i%20want%20the%20amount%20owed%20at%20the%20bottom%20to%20reflect%20the%20new%20total%2C%20with%20the%20cell%20next%20to%20the%20bottom%20one%26nbsp%3B%20still%20reflecting%20starting%20amount%20that%20was%20owed%2C%20Is%20it%20possible%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131006i234EB87398B9C837%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
crichter
Occasional Visitor

I need help with a formula that adds cells in a range that do not have a fill color, As things are getting paid i'm filling in the boxes with the color and i want the amount owed at the bottom to reflect the new total, with the cell next to the bottom one  still reflecting starting amount that was owed, Is it possible?

clipboard_image_0.png

Related Conversations
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Consolidating data from multiple worksheets
Machala Sentance in Excel on
3 Replies
Merge Cells with Different Data Types
CaffeineKing in Excel on
2 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies