|
|
#2
01-01-2024, 04:44 PM
|
||||
|
||||
What's wrong with the calc you have? If the Wanted is giving you what you want, what needs to change?
Could use AVERAGEIF but would need to include year in Quarter calculation. =YEAR(A2) & ROUNDUP(MONTH(A2)/3,0) Then use that in AVERAGEIF. =AVERAGEIF($B$2:$B$34,"=" & B2,$C$2:$C$34) If you want to extract year/quarter from date value for use in formula without having to calculate in a column, sorry, don't know that. Every example I find shows using helper column. 
|
| Tags |
| excel 2013 formula |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula Copy Row 2 Row But Next Column In Formula From Another Tab | TimG | Excel | 3 | 04-16-2018 09:20 PM |
 Formula Help
|
OTPM | Excel | 2 | 10-22-2017 06:38 AM |
|
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Need help with formula
|
zachluke | Excel | 3 | 03-13-2014 11:15 AM |
Windows 10 
Office 2010
Threaded Mode