Array follow up

[trishnmaine]

Jacon Scaria responded to my earlier question. My questions and his response
are below. Wondering ig I can take this further with the following: How
would I calculate for the last 7 Tuesdays based on today's date? Hoping
Jacob can answer or anyone else who has an idea.

Thanks! So glad I found this forum!
Patricia



____________________________________________________________
Try the below. Please note that this is an array formula. An array formula
can perform multiple calculations and then return either a single result or
multiple results. Array formulas act on two or more sets of values known as
array arguments. Each array argument must have the same number of rows and
columns. You create array formulas in the same way that you create other
formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"

Col B date
Col C Sold
=AVERAGE(IF((B2:B1000>0)*(WEEKDAY(B2:B1000)=3)*(B2:B1000>MAX(B2:B1000)-(4*7)),C2:C1000))


If this post helps click Yes
---------------
Jacob Skaria




:

Click to show or hide original message or reply text.

 

[T. Valko]

In the formula: ...(4*7)...

4 represents the number of instances you want to include in the average. So,
for the last 7 instances change 4 to 7. And don't forget: array entered!