Hi,
With an array function, use Control SHift Enter instead of Enter ...
![]()
=AVERAGE(IF(MONTH(A1:A100)=4,B1:B100))
Hi,
With an array function, use Control SHift Enter instead of Enter ...
![]()
=AVERAGE(IF(MONTH(A1:A100)=4,B1:B100))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks