+ Reply to Thread
Results 1 to 4 of 4

Need Excel Formula to count the Total leave take during the month gender wise in one cell

  1. 01-13-2014, 02:01 PM #1
    senthile
    senthile is offline
    Registered User
    Join Date
    09-19-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    61

    Need Excel Formula to count the Total leave take during the month gender wise in one cell

    Hi,
    I have enclosed sample file, need a formula to count Total leave taken during the month gender wise in one cell for each gender. Please let me know is this possible?
    Thanks
    Sen
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-13-2014, 02:16 PM #2
    FDibbins
    FDibbins is online now
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Need Excel Formula to count the Total leave take during the month gender wise in one c

    Hi and welcome ot the forum

    trey this...
    =SUMPRODUCT((C3:C6="M")*(D3:AG6="PL"))+SUMPRODUCT((C3:C6="M")*(D3:AG6="CL"))
    change M to F
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 01-13-2014, 02:53 PM #3
    FDibbins
    FDibbins is online now
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Need Excel Formula to count the Total leave take during the month gender wise in one c

    Thanks for the feedback
    Reply With QuoteRegister To Reply
  4. 01-16-2014, 02:12 PM #4
    senthile
    senthile is offline
    Registered User
    Join Date
    09-19-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    61

    Re: Need Excel Formula to count the Total leave take during the month gender wise in one c

    Can you help me to find the leaves location wise, gender wise total leave. the excel sheet enclosed contain gender wise total leaves. now i am looking for the formula to segregate the same location, gender wise, total leaves
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to count entries as per month, year and submission wise
    By hanidean in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-26-2013, 11:52 PM
  2. Count only when in a certain month & leave that value when in next month?
    By jmogan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-06-2012, 10:15 PM
  3. Supplier Wise month wise totaling
    By Hussain_smh in forum Excel General
    Replies: 3
    Last Post: 02-25-2012, 03:34 PM
  4. Extract from the list and total month wise.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 11:40 AM
  5. Plot data month-wise and month-wise
    By modest_16081982 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-08-2008, 04:44 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1