Sum based on cell color in row

[atuljadhavnetafim]

Hi ,

i have excel with multiple column, every column has background color, at last I need total based on color, if I change the color then I automatically added in total.
in below example.
Payment column has yellow color, so i need formula in J colum which get sum only where backround color yellow.
if i change colour of D2 as yellow then the total will be 270.
i can add it manually but i have so many column so need formula.
the column header name (first row) will not change.

 

[Fluff]

In col J do you want to sum all columns with Payment in row 1 regardless of colour?

 

[atuljadhavnetafim]

In col J do you want to sum all columns with Payment in row 1 regardless of colour?

Yes, you can say, I need sum in J column with payment in row 1. but if you give me for color option that will be good.

 

[Fluff]

Ok in J2 copied down

=SUMIFS(C2:H2,$C$1:$H$1,"Payment")

and similar for k2 & L2.
Excel formulae cannot see colour or formatting

 

[atuljadhavnetafim]

Ok in J2 copied down

=SUMIFS(C2:H2,$C$1:$H$1,"Payment")

and similar for k2 & L2.
Excel formulae cannot see colour or formatting

that's good enough, thanks, I am using sumif and sumifs but not this way.
thanks again

 

[Fluff]

You're welcome & thanks for the feedback.