Source

antattack

u/antattack

r/SuggestALaptop•

High Performance Portable Laptop $1350 or less

Valid Form

  • Total budget and country of purchase: US, Budget is around $1100, would like to stay under $1350

  • Do you prefer a 2 in 1 form factor, good battery life or best specifications to your requirements for the money? Pick or include any that apply. Good battery life, performance and portability are the primary requirements. Must also be able to connect to my 5Ghz Wifi channel. I also download a lot of content (movies, music, books, etc) so need the space to be able to store it without slowing down my computer too much.

  • How important is weight to you? Fairly important, looking for something portable without having to sacrifice too much performance.

  • **Which OS do you requir

14
r/excel•

Sumproduct with countif + multiple criteria, excluding duplicates based on date

unsolved

Hey all, here's the problem i'm looking at:

Data: Column A = Host Column B = Event Column C = Cost Column D = Event Date

I'm trying to count in a given month, the number of (new)hosts that throw an event. Once a host has hosted an event I need to exclude that host from future months.

I'm using the following formula to count the number of events in a given month:

=countifs(eventdate,">="&startdate,eventdate,"<="&EOMONTH(startdate,0))

Any help is greatly appreciated.

EDIT: This is what my data set looks like along with what I'm trying to find.

77