Conditional Average

[Kstalker]

Hello again.

Yet another problem in my world of elaborate worksheets.

I need to calculate the MTD average based on todays date.

Have mdae several attempts but clearly do not quite have the skill.


=AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))


Regards

Kristan

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Kstalker]

Excellent.

Cheers Biff, works a treat.

Regards

Kristan

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Clearwater14]

How do I start a new thread? I am a newbie here. tx

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Biff]

You're very close:

Array entered:

=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))

Are you sure you want to EXCLUDE today's date?

To INCLUDE today's date:

=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))

Biff

"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>

[Peo Sjoblom]

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)


"Kstalker" <[email protected]> wrote in
message news:[email protected]...
>
> Hello again.
>
> Yet another problem in my world of elaborate worksheets.
>
> I need to calculate the MTD average based on todays date.
>
> Have mdae several attempts but clearly do not quite have the skill.
>
>
> =AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
>
>
> Regards
>
> Kristan
>
>
> --
> Kstalker
> ------------------------------------------------------------------------
> Kstalker's Profile:
> http://www.excelforum.com/member.php...o&userid=24699
> View this thread: http://www.excelforum.com/showthread...hreadid=397630
>