phillygirl777
Member
Greetings!
I am trying to eliminate the days when the total sales were under $100. For the sake of this example I am eliminating other data from this file. Do I have to insert add column D that sums up sales from apples and oranges and use the logic COUNTIF($D:$D,">=100), or is there a fancy way to add values in two columns that appear in the same row (sales on the same day) and incorporate it in this formula? Any input is greatly appreciated.
I am trying to eliminate the days when the total sales were under $100. For the sake of this example I am eliminating other data from this file. Do I have to insert add column D that sums up sales from apples and oranges and use the logic COUNTIF($D:$D,">=100), or is there a fancy way to add values in two columns that appear in the same row (sales on the same day) and incorporate it in this formula? Any input is greatly appreciated.
