Count cells complication 1

[EcoWill]

Hi all - I had good luck yesterday from Skip where I used SUMIF to get the sum of values in an separate column where Col1 repeated Mon - Friday over and over down the page, but today i need to COUNT how many cells that have values in them (instead of adding them together) i,e, all the Tuesdays that have values (>0) how many cells are they? Because if i know that, than i can take the sums from yesterday and divide by the count of cells to get an average. (you see it is important not to include '0' (zero) value cells in the count.)

 

[SkipVought]

COUNTIF().

Read the HELP.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[EcoWill]

I know. read the help. You are right but sometimes I am not sure where to look. I will try this.

 

[SkipVought]

and is your version of Excel 2007+?

If so you can use the SUMIFS() function where the first range & criteria is for the WEEKDAY and the second range & criteria is for the VALUE
[tt]
=SUMIFS(rng1,"Tue",rng2,"<>0")
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}