Thread: [Solved] I need a formula to do this !!!!
View Single Post
 
Old 01-02-2024, 08:57 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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.
Reply With Quote