I need a formula to do this !!!!

		Microsoft Office Forums > Microsoft Excel > Excel
I need a formula to do this !!!!

01-02-2024, 08:57 AM

p45cal

Windows 10 I need a formula to do this !!!!

Office 2021

Expert

Join Date: Apr 2014

Posts: 962

Takes into account year and quarter, in cell D2:

Code:

=AVERAGE(IF(((YEAR($A$2:$A$34)=YEAR(A2))*($B$2:$B$34=B2))<>0,$C$2:$C$34))

copied down.

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 PM.