• 0

Google Sheets: COUNT.IF over multiple cells

Asked by Wannes,

 Share

Question

Grand Master

Wannes

Posted
Posted

Hi all,

 

Strange questions and didn't know where to go so I'm puting it down here. Hopefully in the correct place otherwise, please move.

I have a Google Sheets document filled with raw data and would like to know per company name how many records they have published, between certain dates (= per month).

  

Column A		Column B		Column C 		...
Neowin			16/11/2021		Bla bla
Windows			12/11/2021		Meh meh
Microsoft		01/11/2021		Moh moh
Neowin			03/11/2021		Lalalala
Neowin			02/12/2021		Sololal
Windows			01/09/2021		Lasoldo
Microsoft		06/08/2021		Boe Boe
Windows			07/07/2021		Boe La Bam
Windows			03/04/2021		Shakalaka
Neowin			06/09/2021		Tripiedipp

 

I would like to know how many records "Neowin" has in the month november. If I use the =COUNT.IFS formula than the return would be 4 as the formula counts 2x Neowin in column A and 2x the month November in column B. I need the result to be 2 because Neowin has 2 records in november. If I were to do the same excercise for Microsoft the result would be 1. 

 

Anyone an answer to my, probably, simple question?

 

Thanks,

W.

3 answers to this question

Recommended Posts

  • 0
Grand Master

Wannes

Posted
  • Author
Posted
  On 17/12/2021 at 11:25, Steven P. said:

No-one?

Expand  

Thanks for backing me up Steven. :) 

 

@ranpan I has to be a formula indeed as I need it for further development. The pivot table can't offer what I need (or I can't use it in the way I want to). However, I did manage to solve it with following formula. Not sure if it's the correct one but it offers the results I needed.  

=countifs(A$2:A$11;"Neowin";B$2:B$11;">=1/11/2021";B$2:B$11;"<=30/11/2021")

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Posts

    • Researcher exposes Microsoft's flawed code that lets attackers access files on your computer

      By skinnyJM · Posted

      Oops...
    • Ashes of the Singularity II announced promising even larger battles, new faction, and more

      By LoneWolfSL · Posted

      Ashes of the Singularity II announced promising even larger battles, new faction, and more by Pulasthi Ariyasinghe A sequel for the 2016-released Ashes of the Singularity has officially been confirmed, and the original developer and publisher duo, Oxide Games and Stardock Entertainment, are back for this release too. Check out the debut trailer above. Ashes of the Singularity II is under development with a significantly expanded team compared to the original, according to today's announcement. It will be adding in a range of fresh units and gameplay systems for real-time strategy fans to dive into. More options for strategic gameplay, more intricate base building, and better enemy AI are listed as features for the new game as well. "Ten years ago, we set a new, literal benchmark for RTS games with massive battles and groundbreaking technology," said Brad Wardell, CEO of Stardock Entertainment. "With Ashes of the Singularity II, we’re raising the bar even higher, delivering strategic gameplay depth that RTS fans have always dreamed of.” The storyline of Ashes of the Singularity II will take place in 2031, with a complete single-player campaign, as well as cooperative and competitive multiplayer modes, being confirmed as features today. Moreover, a third faction is joining the fray this time, with Humans joining the fight alongside the original games' Post-Human Coalition and the Substrate. "Obviously, in the first game, the number one request was to have a human faction," adds Wardell. “Back then, we just couldn’t support having thousands of organic, walking, squishy people in the world and thus had to design in favor of machines. We’re really excited to bring the humans into the war and watch how they fare against the massive mechanical armies of the Substrate and PHC.” Ashes of the Singularity II is targeting a broad 2026 release window, with the team hoping to launch the title as the original celebrates its 10th anniversary. Its Steam store page is already up for wishlisting over here. Disclaimer: Neowin's relationship to Stardock
    • Bing Image Creator now offers OpenAI's GPT-4o image generation model for free

      By Nas · Posted

      How exactly is a FREE image generation model a... Ponzi scheme?!?! I don't love all of these Gen-AI things flooding the market but there's nothing "ponzi" about it.
    • Microsoft Flight Simulator is gaining Jurassic Park to explore, dinosaurs included

      By Skwerl · Posted

      I can't decide if this is tacky or a really fun move for more casual players like myself to enjoy. I'll be curious to see how we are to fly to fictional land masses on a real globe.
    • Microsoft Flight Simulator is gaining Jurassic Park to explore, dinosaurs included

      By Lamp0 · Posted

      How would you know it was tripe, you were a sleep.

  • Recent Achievements

    • One Month Later
      SamZrize earned a badge
      One Month Later
    • Week One Done
      SamZrize earned a badge
      Week One Done
    • One Year In
      SamZrize earned a badge
      One Year In
    • One Year In
      barracuda earned a badge
      One Year In
    • One Month Later
      barracuda earned a badge
      One Month Later

  • Popular Contributors

    1. 1
      +primortal
      724
    2. 2
      +FloatingFatMan
      189
    3. 3
      ATLien_0
      180
    4. 4
      Xenon
      113
    5. 5
      neufuse
      109
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!