I'm sorry, but this still makes no sense to me - perhaps someone else
can understand what you want to do.

Pete

On Jan 9, 6:56*pm, NotExcelingNow
wrote:
Days * * * * * * * * * *Strength
7 * (H40) * * * * * * * *1000(N40) * * * * * * * * I need it to display 1000
when 41-43 are
14 (H41) * * * * * * * *2000(N41) * * * * * * * * not there, 2000 when 42-43
are not there
28 (H42) * * * * * * * *3000(N42) * * * * * * * * and avg 42 & 43 when all
are there. *the
28 (H43) * * * * * * * *4000(N43) * * * * * * * * problem is I need it to
refrence the 7, 14,
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *28 numbers, not
the cells, as the cell
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *order may change

The number of days changes I might have 3, 7, 14, 28, 28, 28, 56
so I need it to list the strength from the individual days and avg the 28s,
or any other day that may have multiple data. *The most days I will have
would be 7.

Can you do an "if" inside another "if"?

=AND(N$40<0,N$41<0,N$42<0,N$43=0,N$44=0,N$45=0, N46=0)<<<<M59

=ROUND((IF(H42=H41,H40=H41),AVERAGE(P40:Q42),(IF(H 41=H42,AVERAGE(P41:Q42),(*P42))),0)



"Pete_UK" wrote:
Please give further details, with examples of what you have and what
you want to achieve.

Pete

On Jan 9, 4:48 pm, NotExcelingNow
wrote:
I have 7 lines of data, with 2 variables each. *if variable #1 is solo the i
need exel to produce sentence "A" with variable #2 in it. *If variable #1 is
= to another variable #1 then I need excel to produce sentence "B" with the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. *I will try to explain better
if I get a response.- Hide quoted text -

- Show quoted text -