Counting Occurrences based on Content

[Frank Bacchus]

Hi all:

I have a Risk Tracking sheet which currently has 50 rows but can grow daily. I would like to count the number of "Open" or "Closed" or "Transferred" risk items denoted in column C. So as the table grows, the counts should change automatically. The summary (counts) table is in a separate sheet than the detail information. How can I write a formula to do this, keeping in mind that the detail entries will change and the number of rows will grow.

Thanks in advance.

 

[NARAYANK991]

Hi ,

The two standard ways to do this are :

1. Have your data in an Excel table ; you have used the word table in your post , but if it is an Excel table , then formulae using structured referencing will automatically adjust to fresh data within the table.

2. Create dynamic named ranges to refer to your data ; as more data is added , the dynamic named range will automatically extend to include this added data.

Narayan

 

[Frank Bacchus]

Hi ,

The two standard ways to do this are :

1. Have your data in an Excel table ; you have used the word table in your post , but if it is an Excel table , then formulae using structured referencing will automatically adjust to fresh data within the table.

2. Create dynamic named ranges to refer to your data ; as more data is added , the dynamic named range will automatically extend to include this added data.

Narayan

Thanks for responding. I have never created dynamic named ranges. do you have am example?

 

[NARAYANK991]

Hi ,

This is already well explained in several websites ; check out any of the following :

http://www.contextures.com/xlNames01.html

http://www.exceluser.com/formulas/dynname1.htm

https://exceljet.net/lessons/how-to-create-a-dynamic-named-range-with-offset

http://analyticsdemystified.com/exc...ranges-never-manually-updating-your-charts-2/

http://www.ozgrid.com/Excel/DynamicRanges.htm

Narayan

 

[Frank Bacchus]

Hi ,

This is already well explained in several websites ; check out any of the following :

http://www.contextures.com/xlNames01.html

http://www.exceluser.com/formulas/dynname1.htm

https://exceljet.net/lessons/how-to-create-a-dynamic-named-range-with-offset

http://analyticsdemystified.com/exc...ranges-never-manually-updating-your-charts-2/

http://www.ozgrid.com/Excel/DynamicRanges.htm

Narayan

Hi ,

This is already well explained in several websites ; check out any of the following :

http://www.contextures.com/xlNames01.html

http://www.exceluser.com/formulas/dynname1.htm

https://exceljet.net/lessons/how-to-create-a-dynamic-named-range-with-offset

http://analyticsdemystified.com/exc...ranges-never-manually-updating-your-charts-2/

http://www.ozgrid.com/Excel/DynamicRanges.htm

Narayan

Thanks Narayan.