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

Excel Database for Grain Inventory...
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
beiswanger
Posted 9/14/2014 21:01 (#4074734 - in reply to #4072607)
Subject: RE: Excel Database for Grain Inventory...



ECIN
Omar,

I think that your approach using the selection boxes and the SUMIF(S) formula will work better than my approach. I had my data table set up like yours pictured with autofilters and made a summary section at the top of the worksheet using SUBTOTAL based formulas. This worked fine, but because it relied on filtering the data to get results, I could not figure out how to get it to automatically relate to a single value like "acres" based on filter selections. I don't know if this makes sense, but regardless, I like how your method works!

Contextures has some neat tutorials on using data validation to create drop down selection lists (like in your yellow highlighted area) that will be very useful in situations like this.
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 cookies)