will countif work for this?

S

Skeeterj

I'm trying to count cells in a row that have '100%' in them from a formula.

I've tried naming the cells that I want (E6, H6, M6, P6) and use:

=countif(name, 100%)

It's not working for me... Suggestions?

Thanks. Steve
 
M

Mattlynn via OfficeKB.com

=COUNTIF(A1:A7,1)

The 100% is set as the number 1 as 0.99 = 99% etc.
I tried this, and it counts the number of 100%'s

Regards
 
M

Mike H

No countif can't do that on a non contiguous range, Try this

=SUMPRODUCT(COUNTIF(INDIRECT({"E6","H6","M6","P6"}),"=100%"))

Mike
 

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

Similar Threads

Using <= in countifs statement 1
How to express a set of cells as a range 3
Excel 2007 - AVERAGEIF on rows that are non-continuous 2
Help with calculation in query!!! 6
countif not working 2
Merging from an Excel file with graphics 1
Is there an Excel Function that can be used in lieu of this formul 5
Excel Countif Function - Calculating Between Two Sets of Values 3

Top