Pulling value from RM sheet.

[aligahk06_]

Dear All,

Hope this email finds you well !

I have a sheet named table where i want to record historical data's based on data available in sheet RM.
For open , i want to count open workorder in table sheet based on columnE (RM sheet) that recorded during 1st sep 2020 to 30 th sep 2020.
it means it only count based on col E irrespecitive of open or close.
2. in Table sheet close column it counts close work order based on COL F ( RM sheet) that count actual finish between 1st sep 2020 to 30 th sep 2020.
All the number count should be as per section mentioned in table sheet.

Please see the attached !!!
Thanks...

 

[Gasman]

Put a formula in a colum for month and year of your date column, here it is E2, copy the formula down as far as needed
=MONTH(E2)&YEAR(E2)
Same for 2 with column F, then use CountIF() on that column

 

[arnelgp]

here is your sheet.
note: i added Start Date (Table!C2) and End Date (Table!D2).
these cells have their Forecolor to White so it
appears there is no value on those cells.