I want a formula to do this.
I am calculating how many gallons i pumped i have two wells only one well runs a day, alternating each day.
column A is hours well one ran Column B is hours well 2 ran in column C is the total gallons pumped from one of the wells 1 or 2 which ever ran that day. I want column D to reference how many gallons pumped from column C but only if Column A had a number greater than 1 how do i do this?

Attached Files

Well Spread Sheets.xlsx (10.1 KB, 9 views)

Like this?

Attached Files

Copy of Well Spread Sheets.xlsx (10.8 KB, 10 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Just like that!!!! Thanks!