Formula for Avg from 2 columns (last 10 cells) - A newbie User!!

**mitrbikram** · 07-22-2012, 03:59 AM

Hello Everyone

I need some help to develop a formula to find avg of last 10 days and last 5 days
I m total new to this formula developing thingy.

Solve this.PNG

this is the case, I know its simple for u guys..

I just want the cell to show avg per tap
like for 10 days we need to add last 10 cells of product column and divide it by sum of last 10 cells in taps used column
thats it i tried but in vain.. i dont know why..

Also i want it be blank for present and future dates. (not compulsory)

thanks in advance

**dilipandey** · 07-22-2012, 04:10 AM

Hi bikram,

Welcome to the forum.

Suggest you to change the thread title to reflect the query you are asking.. see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

**mitrbikram** · 07-22-2012, 05:21 AM

Changed from

"Formulae Required - A newbie User!!"

to

"Formula for Avg from 2 columns (last 10 cells) - A newbie User!!"

Thanx (Star Given)

**dilipandey** · 07-22-2012, 05:39 AM

Thanks Bikram Mitra

Also would appreciate if you could upload a sample workbook for quick practical try

Regards,
DILIPandey

<click on below 'star' if this helps>

**mitrbikram** · 07-22-2012, 08:08 AM

aww.. Got a local help and formula developed... yippie!!

It was quite simple by writing it directly into the cell, before i was trying just by selecting cells.
didnt know that i have to combine 2 formulas.

anyways its done the formula is "=PRODUCT(SUM(E2:E11),1/SUM(D2:D11))"

**mitrbikram** · 07-22-2012, 08:30 AM

Now another development with same workbook.

Should i start a new Topic??
Do let me know if i have to start a new one.

I made 2 extra columns with Last 5-Days Avg and Last 10-Days Avg
But the cell showing error but working (what should i do for that??)

Book1.xlsx

Also i want to make the cell blank for next or new dates as they giving some result
and its disturbing the Conditional formatting (Color Scales).

Also i copy pasted last month's data for result on first dates of this month.

So what changes should i made to this formula.
This is my first workbook so please help..!!

**Cutter** · 07-22-2012, 08:42 AM

Hello mitrbikram, and welcome to the forum.

You should mark this thread as SOLVED (instructions below) and start a new thread for your next question. Thanks.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save