Average multiple ranges of numbers excl zeros

[vicsalt]

Help with what should be a easy solution
I will set the scene

Column named Parts Made, (31 rows 1 for each day dated for every day)
I want to average the parts made on Mon to Fri and make a projection of how many parts we should by month end.
I also want to average the parts made on weekends as its a lot smaller shift)
We will ignore the weekends as the solution will be the same

Im trying to average only the cells with values across multiple ranges it isn't a continuous column of cells if that makes sense, would upload image if i knew how

Thanks for any assistance

 

[Aladin Akyurek]

See: https://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729. Try to post the sample directly here, not a link to it.

 

[NARAYANK991]

Hi ,

Maybe something like this :

=SUMPRODUCT((WEEKDAY($A$2:$A$31,2) <=5) * ($B$2:$B$31 <>""), $B$2:$B$31)/SUMPRODUCT((WEEKDAY($A$2:$A$31,2) <=5) * ($B$2:$B$31 <>""))

 

[vicsalt]

wow that sounds complex

 

[vicsalt]

I want to average the highlighted cells

 

[vicsalt]

https://farm5.staticflickr.com/4455/24334151848_67259580d1_m.jpg

 

[Aladin Akyurek]

Not a picture or an image. Better: Just data that can be copied from the board and pasted into Excel (without retyping anything).

 

[vicsalt]

how ?

 

[Aladin Akyurek]

how ?

See the link in post #2 which enumerate some options.

 

[vicsalt]

Would be nice for someone to offer advice on a solution, Ive explained the issue, all getting off track