A counting question

  • Thread starter Thread starter sjackson
  • Start date Start date
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.
 
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
 
In this workbook, there will be multiple Mondays, I am trying to coun
the numbers for an entire year
 
You must log in or register to reply here.

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

Worksheet Function required 2
Help on Count If Statement 5
Countif, index and match 2
Count in a range of numbers 8
SUMIFS ONLY UNTIL the number REPEATS 1
SUM / COUNT formula 3
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Checking for how many occurances, given two different criteria 1

Back
Top