Forum Discussion

Murray1985's avatar
Murray1985
Copper Contributor
May 16, 2021

Look up values equal or less than 3 based in a specific month

Hello I am looking for a formula to calculate how many records in a month are equal to or under a certain value? For example: I have a list of site visits which have a date in column O of when they w...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
May 16, 2021

Murray1985 

My apologies, you did mention that you wanted to count records, but then I misread the remainder of your post.

In B13:

 

=COUNTIFS('Call outs'!$O$3:$O$65,">="&B11,'Call outs'!$O$3:$O$65,"<="&EOMONTH(B11,0),'Call outs'!$V$3:$V$65,"<=3")

 

This is an 'ordinary' formula, you don't have to confirm it with Ctrl+Shift+Enter.

 

Copy to D13, F13 etc.

Murray1985's avatar
Murray1985
Copper Contributor
May 16, 2021

HansVogelaar Thanks this seems to work however I have attached the spreadsheet again as for some reason even though there is no data in column v on the "Call outs" sheet, a value is returned in cells C13, E13, G13, I13, K13, W13 & Y13 on the "KPI's" sheet??? Could you help me please?

 

Thanks

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 17, 2021

    Murray1985 

    There are values in column V but they have been hidden somehow.

    Select V3:V4336 and select Clear > Clear Formats on the Home tab of the ribbon.