Results 1 to 4 of 4

CountIFS roll up to one value- Sum the one time month is called out

Threaded View

Shruder CountIFS roll up to one... 03-12-2018, 08:45 PM
Estevaoba Re: CountIFS roll up to one... 03-13-2018, 12:22 PM
Shruder Re: CountIFS roll up to one... 03-13-2018, 04:51 PM
Estevaoba Re: CountIFS roll up to one... 03-14-2018, 02:39 PM
  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    199

    CountIFS roll up to one value- Sum the one time month is called out

    I am looking for a formula that will Count the month (A) for any "x" value in (L). And count that month within the year column (B).

    So for example is (A) counts "1" as the value in 2017. But let's say there are 30 counts of "1" in (A). I just want in another cell the formula to return the "1" where the value equals "x" in column (I). Something where I can drag the formula down and hopefully it will look just return the first time a month is called out in (A) where there is an "x" in column (L).

    similar to what the pivot is doing below which I want to get rid of.

    It is counting months 1-12, but only returning a count with the cells that have values.

    In the case of the pivot, the cells with values are sums on column (I) in this data tab.

    I have this formula in there now, but it won't work in full like I need it to.

    =COUNTIFS(I:I,"x",A:A,1,B:B,2017)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need VBA code to roll when I roll date in file
    By scrivenk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2018, 07:52 PM
  2. Vacation Accrual With 3 Month Roll Over
    By johnknight in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-29-2014, 08:32 AM
  3. Replies: 14
    Last Post: 03-05-2014, 10:52 AM
  4. [SOLVED] Need To Add time in Column up to 24hr then roll over the date
    By ValleyJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-14-2013, 08:08 PM
  5. Roll Assgnment - Items per month count
    By DUBBAVEE in forum Excel General
    Replies: 1
    Last Post: 11-30-2011, 01:05 AM
  6. Making Time roll over after 24 hours
    By Emil240 in forum Excel General
    Replies: 12
    Last Post: 11-26-2009, 04:02 AM
  7. [SOLVED] have invoice # roll up, or add 1, each time document is opened
    By Syndee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2006, 08:35 AM

Tags for this Thread

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