+ Reply to Thread
Results 1 to 3 of 3

To sum up the Datas of a particulars in a column

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    332

    To sum up the Datas of a particulars in a column

    I have a sheet pertaining to datas plant wise.I have 3 plants datas having month wise figures e.g.Apr'10~Aug'10.Each plant have a fig.in a specific month with their different heads.Now,I want the sum of all my 3 plants into a summary column.I am applying the sum of a plant by adding formula one by one.It is very cumbersome formula.Is there any formula to solve the problem by Excel?

    Please refer the attached sheet.

    Regards

    Pradeep Kumar Gupta
    Attached Files Attached Files
    Last edited by PRADEEPB270; 09-25-2010 at 02:39 AM.
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: To sum up the Datas of a particulars in a column

    In C6 try...

    =SUMIF($F$5:$T$5,C$5,$F6:$T6)

    ...drag down and over

  3. #3
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    332

    Re: To sum up the Datas of a particulars in a column

    Thank you very much sir.

    Regards

    Pradeep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1