HARDLYEVER
New Member
 Joined
 Aug 25, 2020
 Messages
 3
 Office Version

 2013
 Platform

 Windows
I'm trying to multiply percentages if they meet a certain criteria and not having much luck.
The worksheet looks like this.
I want to multiply column A if column B equals Blue.
I tried following some examples found within the forum such as {=PRODUCT(IF(B2:B5="BLUE",A2:A5))} (Ctrl+Shift+Enter) which works. However this worksheet is several thousand rows. When i extend the row criteria to A:A or A2:A300 i get #NA.
Thanks,
The worksheet looks like this.
A  B 
88%  Blue 
55%  Red 
34%  Blue 
86%  Green 
I want to multiply column A if column B equals Blue.
I tried following some examples found within the forum such as {=PRODUCT(IF(B2:B5="BLUE",A2:A5))} (Ctrl+Shift+Enter) which works. However this worksheet is several thousand rows. When i extend the row criteria to A:A or A2:A300 i get #NA.
Thanks,