Counting Results of Formulas


J

jgupte

I have a column in a spreadsheet that contains the result of a a lookup
function (refering to values in another spreadsheet) and displays a blank
field if the lookup does not find a match in the second spreadsheet.

I need to count how many matches are found (or not found). But when I use
the count function, it seems to be counting the formula and not the result of
the formula.

Does this make sense?

Example:

Formula of cells B10:B1500 = IFERROR((VLOOKUP(C45,'[Completed Property
List.xls]Sheet1'!$A$2:$B$10000,2,FALSE)),"")

- displays the contents of matching cell in column B of Completed Property
List if a match is found in column A, otherwise displays a empty cell.

Then I use the count function to count how many matches were found (or if
cells in the range B10:B1500 have anything in them besides the formula)

=COUNTIF(B10:B5000,"*")

Examples of contents of cells B10:B1500

Newcastle (result of formula)
Newcastle (result of formula)
(blank displayed, contains formula)
(blank displayed, contains formula)
Albury (result of formula)
Canberra (Manually entered text)
Albury (result of formula)

Thr result I would like to achieve is a count of 5 (or 2)


Newcastle
 
Ad

Advertisements

T

T. Valko

Try these...

This will count cells that contain *text only* and will *exclude* any cells
that contain formula blanks "".

=COUNTIF(B10:B5000,"?*")

To count the blank *and* empty cells:

=COUNTBLANK(B10:B500)
 

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

Lookup returning wrong results 0
Counting results of a formula 9
count nonblank cells 3
count - but exclude counting cells with a formula 4
nth row or column counting 1
match formula 2
array formula 2
Excel Import Comments 3

Top