Excel gives two very simple built-in formulas to tackle counting and summing in rows or columns primarily based on standards that you simply create. The formulas mentioned during this posting are COUNTIF and SUMIF.
COUNTIF
This method will evaluate information within a collection consisting of single row or column, or adjoining rows or columns. For instance, you could possibly evaluate information inside the column defined by A1:A20, otherwise you can be shopping at A1:B20. possibly collection is acceptable to utilize for your COUNTIF purpose. The kind on the method is:
=COUNTIF(Range,Criteria).
Let us say, for instance, that you simply are keen on identifying the complete variety of revenue within a area, with areas staying defined as North, South, East and West, therefore you have everyday revenue for just about every area for any five-day period of time. The very first stage may well be to identify the number of revenue around the five-day period of time exceeded thirty models a day. additional presume that our area names are inside the collection C6:C9 with corresponding unit information in D6:H9. The method to locate unit revenue around thirty could be =COUNTIF(D6:D9,"
0 comments:
Post a Comment