Need help with a conditional formatting
I would like help with a conditional formatting.
I would like every value in a column that is true to then look across at a different column and add the total
2 Europe TRUE FALSE FALSE FALSE FALSE
2 Vietnam TRUE FALSE FALSE TRUE FALSE
2 Europe TRUE FALSE FALSE TRUE FALSE
2 Europe FALSE FALSE FALSE TRUE TRUE
1 London TRUE FALSE FALSE FALSE FALSE
2 Vancouv TRUE FALSE FALSE FALSE TRUE
1 Munich TRUE FALSE FALSE FALSE FALSE
4 Europe TRUE FALSE FALSE TRUE FALSE
1 Central TRUE FALSE FALSE FALSE FALSE
For example, the far right column contains two true values. I want the cells that contain true to then go across and add the two 2's together.
Second example. Second last column has 4 true values. Want it to locate the trues then add the corresponding values in the first column. ie 2+2+2+4 so the value of the formatting would be 10.
Thanks in advance.
SUMIFS
Your going to be looking at using the SUMIFS Function, something like:
=SUMIFS(A1:A9,C1:C9,TRUE)
Will give you your result for the third column.
ah, sorry, just notived you are looking for a conditional formating tip, not a summing tip. I didn't read the question properly.
Was about to post the same
Was about to post the same thing - I think he does want what you posted. :)