narsing rao
Member
Hi,
I have 2 sheets
sheet1 is a Summary sheet and sheet2 is data sheet
sheet 2 has columns from A TO R, in that column G is Severity (heading) with four values Sev-1, Sev-2, Sev-3,Sev-4 and J is date Field with heading Lodgeddate.
i want to calculate severity count for today, this month, this financial quarter, last quarter, older than last quarter.
i have used below formula to check sev-1 count in sheet2 but its not showing any value but just showing #VALUE! Symbol
please help to solve this problem.
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !
I have 2 sheets
sheet1 is a Summary sheet and sheet2 is data sheet
sheet 2 has columns from A TO R, in that column G is Severity (heading) with four values Sev-1, Sev-2, Sev-3,Sev-4 and J is date Field with heading Lodgeddate.
i want to calculate severity count for today, this month, this financial quarter, last quarter, older than last quarter.
i have used below formula to check sev-1 count in sheet2 but its not showing any value but just showing #VALUE! Symbol
please help to solve this problem.
Code:
=COUNTIFS(Sheet2!G:G,"sev-1",Sheet2!J:J,">=1-Mar-2017",Sheet2!J:J,"<31-Mar-2017")▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !