Need help with an IF formula

Hi Kate

You did explain it well. There are 2 methods that come to mind. One is to use a COUNTIFS function and the other is to use a Pivot Table.

I've made up some sample data in Column A so you can see which method is more practical

Countifs Method

To calculate 41-120
=COUNTIFS($A$2:$A$16,">40",$A$2:$A$16,"<121")
To calculate >120
=COUNTIF(A2:A16,">120")

Days
46
74
32
94
152
177
198
112
10
26
50
113
62
96
77

PivotTable method

With cursor in A1 choose Insert, Pivot table
Choose existing worksheet cell eg E5
Row Headings - Days
Value - Days - Summarize as Count
Then group the resulting data as follows (right click any value in the pivot table and choose Group)

Starting at 41
Ending at 120
By: 79

This is how the Pivot table displays:

Row Labels Count of Days
<41 3
41-120 9
>120 3
Grand Total 15

The Pivot table doesn't involve writing formulas but will need refreshing if data changes.
Hope that helps.

Doug Dunn
Best STL

Read more: https://www.stl-training.co.uk/post-34325-urgent-formula-help-needed.html #ixzz2m1v8JH85