Hi,
Is there a formula to add values of cells based on conditioning formatting? I would like to add up all of the numbers in green to give me the sum of those?
I have attached sample
Thanks
Douglas
Hi,
Is there a formula to add values of cells based on conditioning formatting? I would like to add up all of the numbers in green to give me the sum of those?
I have attached sample
Thanks
Douglas
Basically you filter it (I had to look this one up too...)
Here's my source:
:: BatNoob
' BatNoob
/* BatNoob*/
Thanks,
I've tried that one as well but when you change the filters on the other suppliers the value for that particular one also changes. I need a formula that will work without applying filters.
It appears that the rule for the green highlighted cells is the minimum (bottom 1) value from each row. That being the case I propose the following:
1) Populate column I using: =MIN(D3:H3)
2) Populate column J using: =INDEX(D$1:H$1,MATCH(I3,D3:H3,0))
If the goal is to get a total of all minimums then use the following in I38: =SUM(I3:I35)
If the goal is to get the total from each supplier then use the following in D40:H40 =SUMIFS($I3:$I35,$J3:$J35,D1)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Double post???
https://www.excelforum.com/excel-gen...ormatting.html
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks