+ Reply to Thread
Results 1 to 6 of 6

sumproduct formula for summing desingation wise

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    sumproduct formula for summing desingation wise

    Hi
    Please find attched a sample file
    I would like to arrive the amount paid designation wise in colum in AY COLUM using sumproduct without pivot table
    pls help
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: sumproduct formula for summing desingation wise

    Hi,

    Try the following in AY4:

    =SUMPRODUCT(--(D$4:D$73=AX4),AR$4:AR$73)

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: sumproduct formula for summing desingation wise

    Hi
    It works great
    Thanks

  4. #4
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: sumproduct formula for summing desingation wise

    HI
    can you please give formula for count of designation according to gender without pivot table
    I am getting some trouble there
    Pls help

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: sumproduct formula for summing desingation wise

    Quote Originally Posted by cbatrody View Post
    =SUMPRODUCT(--(D$4:D$73=AX4),AR$4:AR$73)
    More efficient...

    =SUMIF(D$4:D$73,AX4,AR$4:AR$73)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,362

    Re: sumproduct formula for summing desingation wise

    Try

    =COUNTIFS(D:D,AX4,E:E,"M")

    and

    =COUNTIFS(D:D,AX4,E:E,"F")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to colum wise data to Row wise- data
    By srinivasan1965 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-08-2015, 10:25 AM
  2. [SOLVED] VBA -- Need help in Summing values from Visible Cells (row-wise)
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-07-2014, 09:37 AM
  3. vba code for automating branch wise day wise amount to summary file
    By pranithpm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 04:18 AM
  4. Excel code to represent data from row wise to column wise
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 03:45 AM
  5. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  6. Data row wise, formula column wise
    By Fred Smith in forum Excel General
    Replies: 4
    Last Post: 12-09-2005, 11:55 AM
  7. Delete row wise duplicates & colomun wise simultaneously excel
    By Dipankar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 09:05 AM

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