View Single Post
  #1   Report Post  
TBoe
 
Posts: n/a
Default Summing 2 columns

I can't seem to figure this out...here's an example spreadsheet.

1 blue red
2 red red
3 blue blue
4 red red
5 red blue

I trying to get the sum of red only when red is equal in both columns.
In this case the the total would be 2. I tried count and sum if but I think
my syntax is all wrong. Thanks so much..............

Terry