Unsure what formula to use

[Cdsilcox]

I track injuries for my company, and I need to track which type of injuries have occurred in the last 90, 30, and 7 days.

for example
Column G: Body part affected by injury
Column B: Date of injury

In Column G I need to know how many times the body part "Arm" occurs within the last 90 days. What formula could I use to correctly count these occurrences?

I have tried several countifs functions to no prevail.

 

[Joe4]

Welcome to the Board!

Try something like this (for Arm in the past 90 days):

=COUNTIFS(G1:G100,"Arm",B1:B100,">=" & (TODAY()-90))

 

[63falcondude]

Something like this? Obviously you will have to adjust the ranges to fit your data.

Excel 2010

	B	C	D	E	F

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Date of Injury[/TD]
[TD="align: center"]Body Part Affected[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Body Part[/TD]
[TD="align: center"]# times within last 90 days[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]2/3/2016[/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]5/12/2016[/TD]
[TD="align: center"]Leg[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]5/14/2016[/TD]
[TD="align: center"]Hip[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]6/11/2016[/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]7/7/2016[/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F2[/TH]
[TD="align: left"]=COUNTIFS(B:B,">="&TODAY()-90,C:C,E2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Cdsilcox]

Awesome this worked! I was using this formula before except I had it reversed in order and it wouldn't work! Thank you so much!

Something like this? Obviously you will have to adjust the ranges to fit your data.

Excel 2010

	B	C	D	E	F

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Date of Injury[/TD]
[TD="align: center"]Body Part Affected[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Body Part[/TD]
[TD="align: center"]# times within last 90 days[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]2/3/2016[/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]5/12/2016[/TD]
[TD="align: center"]Leg[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]5/14/2016[/TD]
[TD="align: center"]Hip[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]6/11/2016[/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]7/7/2016[/TD]
[TD="align: center"]Arm[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]F2[/TH]
[TD="align: left"]=COUNTIFS(B:B,">="&TODAY()-90,C:C,E2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Cdsilcox]

This is how i was originally trying it but it wouldnt work. However, for some reason by switching the order, it worked! Thank you for your time and response.

 

[63falcondude]

Awesome this worked! I was using this formula before except I had it reversed in order and it wouldn't work! Thank you so much!

Glad to help!