Count Function

[Neico]

Hello

I need a count function that meets the following criteria (see attached screenshot). I need to count per country the number of years of Democracy (dummy variable) until 1925, 1950, 1975, and 2000 respectively.
Does anyone have an idea?

Thanks!

[ashishmehra2010]

Hi Neico,

Please attach a sample excel since pictures are hard to do any sort of editing.

Regards,
AM

[Neico]

thanks I attached it

[Neico]

I tried this but it isn't working

=SUMIFS(p4v2013!L2:L16728,p4v2013!D2:D16728,Sheet1!A2,p4v2013!E2:E16728,"<=H1")

[Neico]

Sorry, attached is a new screenshot to make this clearer

[Neico]

I figured it out with a pivot table
thread can be closed
thanks

[ashishmehra2010]

Perhaps you could post the output file for better understanding.

Regards,
AM

[adhawan06]

Hi Neico - if your requirement has been fulfilled, please take few seconds to mark this thread SOLVED so other user may not land here to solve your query.

Hope this make sense.

[sandy666]

sth like this?

Workbook1_sandy.xlsx

edit:
too late