9727

Using SUMIF or SUMIFS in excel sheet

Question:

I have data in the sheet like

Emp JID Sumt 1004 1001 2 1142 1001 4 1166 1001 6 1167 1001 1 1169 1001 4 1170 1030 3 1171 1031 6 1172 1031 4 1173 1041 3 1174 1041 5 1145 1030 3 1088 1012 4.1 1123 1001 1 1102 1031 4 1122 1001 4

And i trying to sum up <em>sumt</em> based on JID coulmn, if JID has the same id's like 1001 Sumup column <em>Sumt</em> data.And result should be

JID result 1001 22 1030 6 1031 14 1041 8

How do i specify in a formula? I tried using DSUM but it returns #Value error. Is the SUMIF right formula?

Answer1:

SUMIF is appropriate, but a pivot table would be more versatile, updating easily when new JIDs are added

Answer2:

If your records start from column "A" then the following SUMIF should work:

=SUMIF(B:B;1001;C:C)

As far as I understood, you want to sum all values from column <strong>Sumt</strong> if column <strong>JID</strong> equals <strong>1001</strong>.

Recommend

  • How to get the count of each distinct value in Multiple columns and get the result in separate colum
  • Google analytics collect parameter “a”
  • DSUM in Access query yields Nulls in random records
  • Getting MucConfigurationNotSupportedException In android smack 4.2.0-beta1
  • Getting error while dealing with getter and setter in kotlin
  • Android Intent to call Whatsapp from code
  • Android Room - reset auto generated key on each app run
  • SQL server wrong Row Number is showing
  • non-negative integer solutions to system of linear equations in mathematica
  • Why Touch not work on google map v2?
  • What exactly is the height of modalPresentationStyle - FormSheet on iPad?
  • calculating number of bytes of each row in an image
  • Excel distinct count with conditions
  • revitapi ironpython ToRoom returns “indexer # object”
  • Access variable of ScriptContext using Nashorn JavaScript Engine (Java 8)
  • App restarts from wrong activity
  • Needing to do .toArray() to get output of mongodb .find() on key name not value
  • CakePHP 2.0.4 - findBy magic methods with conditions
  • Use of this Javascript
  • Replace value with Factor in r data.table
  • C++ Partial template specialization - design simplification
  • How to access EntityManager inside Entity class in EJB3
  • Repeat a vertical line on every page in Report Builder / SSRS
  • PHP - How to update data to MySQL when click a radio button
  • Is possible to count alias result on mysql
  • How to redirect a user to a different server and include HTTP basic authentication credentials?
  • what is the difference between the asp.net mvc application and asp.net web application
  • Upload files with Ajax and Jquery
  • How to get next/previous record number?
  • Apache 2.4 - remove | delete | uninstall
  • Numpy divide by zero. Why?
  • php design question - will a Helper help here?
  • How to delete a row from a dynamic generate table using jquery?
  • Python: how to group similar lists together in a list of lists?
  • json Serialization in asp
  • AngularJs get employee from factory
  • Rails 2: use form_for to build a form covering multiple objects of the same class
  • How to stop GridView from loading again when I press back button?
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • Authorize attributes not working in MVC 4