How about in D3 copied down...
=SUMPRODUCT(--(A3='Protein Data'!$B$2:$B$35),--($I$2=TEXT('Protein Data'!$A$2:$A$35,"mmmm")),'Protein Data'!$C$2:$C$35)
Stretch the range as far as you need...
How about in D3 copied down...
=SUMPRODUCT(--(A3='Protein Data'!$B$2:$B$35),--($I$2=TEXT('Protein Data'!$A$2:$A$35,"mmmm")),'Protein Data'!$C$2:$C$35)
Stretch the range as far as you need...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks