Perhaps the following will be of some help.
Populate AJ42:DA42 using: =COUNTIFS(AJ3:AJ35,MIN(AJ3:AJ35))
Get a sum of the values in AJ42:DA42 that a visible using: =SUMIFS(AJ42:DA42,AJ2:DA2,"Calc Annual Value*")
Let us know if you have any questions.
Perhaps the following will be of some help.
Populate AJ42:DA42 using: =COUNTIFS(AJ3:AJ35,MIN(AJ3:AJ35))
Get a sum of the values in AJ42:DA42 that a visible using: =SUMIFS(AJ42:DA42,AJ2:DA2,"Calc Annual Value*")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks