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.

andycr's picture

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. :)