AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Subtract-if formula?
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
Future Farmer11
Posted 2/4/2019 20:22 (#7297280)
Subject: Subtract-if formula?

I attached a sheet of my oil change worksheet. In the Hours on oil column I would like it to automatically subract the miles from the previous time I selected "changed" in the Oil Column. Currently it just subtracts the current row from the row above. The problem is if I do other work on the piece of equipment, it still subtracts the the miles and figures it in the oil column. The only way I can get around it is to not put miles in the row, but I don't like doing it that way. Thanks for any help.

Attachments NAT- Sumif.xlsx (14KB - 147 downloads)
Top of the page Bottom of the page

Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete all cookies set by this site)