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,