Forum Discussion

brooij_bdr's avatar
brooij_bdr
Copper Contributor
Sep 27, 2019
Solved

Table with start date & end date, count cells on specific date

Hi,   I have a worksheet regarding a car collision repair workshop (see attachment).   Table 1 Column B - case number Column C - car brand Column D - car model Column E - start date Column F...
BI & Data Analysis
Charting
excel
Formulas and Functions
office 365
power bi
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Sep 27, 2019

    brooij_bdr 

    See if this is what you are trying to achieve...

     

    In J10

    =COUNTIFS(Data[Brand],"<>",Data[Date S],"<="&I10,Data[Date E],">="&I10)

    In K10

    =COUNTIFS(Data[Fuel type],K$9,Data[Date S],"<="&I10,Data[Date E],">="&I10)

    In L10

    =COUNTIFS(Data[Fuel type],L$9,Data[Date S],"<="&I10,Data[Date E],">="&I10)

    In M10

    =COUNTIFS(Data[Fuel type],M$9,Data[Date S],"<="&I10,Data[Date E],">="&I10)

     

Resources