Trying to figure the formula

L

llHermesll

Is there a way to alter a COUNTIF formula to only take into account th
visible cells when autofiltering.

I.e
[image: http://img.photobucket.com/albums/v46/jamilius/excel.jpg]
I have a spreadsheet where Column A is Week (Week 1, Week 2, etc) Colum
B is for Names and Column C contains "Yes", "No" and "N/A".

Currently i use =100%-(COUNTIF(C2:C10, "No")/COUNTA(C2:C10)) t
calculate a percentage total of Yes and N/A's

What i need to do is autofilter by week, and give a percentage total o
the filtered values.

For example if i autofilter Week 1 from this example the Percentag
Total should read 66% or Week 3 would read 33%

Any and all help would be appreciated if you need any more info let m
kno
 
D

Don Guillett

Is there a way to alter a COUNTIF formula to only take into account the
visible cells when autofiltering.

I.e
[image: http://img.photobucket.com/albums/v46/jamilius/excel.jpg]
I have a spreadsheet where Column A is Week (Week 1, Week 2, etc) Column
B is for Names and Column C contains "Yes", "No" and "N/A".

Currently i use =100%-(COUNTIF(C2:C10, "No")/COUNTA(C2:C10)) to
calculate a percentage total of Yes and N/A's

What i need to do is autofilter by week, and give a percentage total of
the filtered values.

For example if i autofilter Week 1 from this example the Percentage
Total should read 66% or Week 3 would read 33%

Any and all help would be appreciated if you need any more info let me
know

Have a look in the help index for SUBTOTAL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top