CountIf by month

[Citrusandsage]

I have a spread sheet that has billing data from December 2020 through April 2021 by customer account number (starting in column C Row 6) the customer account number is duplicated based on the billing for each product sku. I need a unique customer count but I need it by month. I am currently using =IF(COUNTIF((C$6:C6,C6)=1),1,0) which works for count however is there any way I can add an additional criteria that only puts a 1 for the first instance of the account number by month.

 

[jasonb75]

Assuming dates in column B, try

=--(COUNTIFS(C$6:C6,C6,B$6:B6,">"&EOMONTH(B6,-1),B$6:B6,"<="&EOMONTH(B6,0))=1)

 

[Citrusandsage]

Assuming dates in column B, try

=--(COUNTIFS(C$6:C6,C6,B$6:B6,">"&EOMONTH(B6,-1),B$6:B6,"<="&EOMONTH(B6,0))=1)

I was so hopeful hahaha I keep getting a false I have date columns and also month column tried both got FALSE

 

[Citrusandsage]

I was so hopeful hahaha I keep getting a false I have date columns and also month column tried both got FALSE

Also to note the dates are not by days it’s always 12/1/2020, 1/1/2020 and so on it’s more of a period and day is always 1 not sure that will effect the formula

 

[jasonb75]

I keep getting a false I have date columns and also month column tried both got FALSE

There is no way that the formula will show FALSE unless you have deleted some of the parenthesis or added things to the formula.

it’s always 12/1/2020, 1/1/2020 and so on it’s more of a period and day is always 1 not sure that will effect the formula

That makes it easier, a big chunk of the formula is for checking the whole month.

=--(COUNTIFS(C$6:C6,C6,B$6:B6,B6)=1)

 

[Citrusandsage]

There is no way that the formula will show FALSE unless you have deleted some of the parenthesis or added things to the formula.

That makes it easier, a big chunk of the formula is for checking the whole month.

=--(COUNTIFS(C$6:C6,C6,B$6:B6,B6)=1)

Awesome gonna try this tomorrow thank you so much