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

Need a little excel help
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Omar
Posted 11/15/2014 07:29 (#4178700 - in reply to #4178124)
Subject: RE: Need a little excel help


Elmira, Ontario

A minor thing, but it will increase flexibility down the road. If you have Excel 2007 or later, use SUMIFS instead. For example:

=SUMIFS($B$3:$B$29,C$3:C$29,"Farm1",D$3:D$29,"Field1")

B column is the data to add, C column contains farm names, and D contains field names. Note the order of items inside the formula are slightly different than SUMIF.

You can later get into limiting things such as dates when you do this. Take it further, and maybe you only want to sum records where you delivered the loads to an elevator, or maybe variety, or whatever you are tracking.

But, to make the multiple criteria work, you need to start with SUMIFS. It's easy to add more criteria later this way.

COUNTIFS and AVERAGEIFS work in similar ways.



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)