A counting question

S

sjackson

Hi, I was wondering if is is possible to count a set of numbers using
more than 1 agruement. I am trying to count a set of numbers as long
as those numbers are not zero and the column is a day of the week. An
example would be:

0.91 1.07 1.07 0.86 0.9 0.97 1.01 1.02 0 0.91


I would like to count all the number is are in the Monday column and
are greater than zero. Any help anyone can give be will be
apperciated.
 
S

sjackson

The columns would end up something like this:

Monday .91, .97, .92
Tuesday 1.07, .86
Wednesday 1.07, 1.02
Thurs. .88, 0
Friday .90, .9
 
S

sjackson

In this workbook, there will be multiple Mondays, I am trying to coun
the numbers for an entire year
 

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

Help on Count If Statement 5
CountIf Question 7
Counting Question 7
Counting consecutive cells 4
How do I count only if either/ or exist 5
Count unique distinct values that meet multiple criteria 1
For-Next by a row Counting consecutive Zero in the column 4
Counting Cells With Multiple Criteria on Multiple Sheets 0

Top