Previous Topic Next Topic

How to calculate values using COUNTIF

Closed
narsing18 Posts 2 Registration date Monday March 27, 2017 Status Member Last seen July 24, 2017 - Mar 27, 2017 at 06:14 AM
 ibrahim - Mar 28, 2017 at 03:04 PM
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

=COUNTIFS(Sheet2!G:G,"sev-1",Sheet2!J:J,">=1-Mar-2017",Sheet2!J:J,"<31-Mar-2017")

please help to solve this problem.

1 response

Answer 1 / 1
ibrahim
Mar 28, 2017 at 03:04 PM
Hi,
I wonder if you could upload a sample file.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response