Counting

  • Thread starter Thread starter Civette
  • Start date Start date
The formulas were not working consistently because some of the cells that
appeared to contain blanks actually had spaces in them and therefore were not
seen as blank by excel. Once I cleared all empty cells of potential spaces,
etc. the =SUMPRODUCT((E4:E869="1247.24")*(AC4:AC869<>"")) worked like a
champ.

Thanks for your help. It's thrilling when you finally figure out what was
causing the problem.
 

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

countifs Function not giving desired result with date criteria 2
Counting cells with specific month in 7
Help with time function 4
If count 6
count number of occurences on a particular date 3
counting cells containing certain ranges of dates 1
Counting Multiple Records by specific criteria 5
I want to count the total Number of dates between two dates How? 3

Back
Top