Forum Discussion
Help with Excel
Hi, so I have data on patents by year and industry code and I would like to group certain industry codes together and sum the number of patents relating to those codes but still separate by year and ...
=SUMPRODUCT((($B$2:$B$13=$F$4)+($B$2:$B$13=$G$4)+($B$2:$B$13=$H$4))*($A$2:$A$13=E5)*$C$2:$C$13)Maybe with this formula for the data layout of the example. In cells F4, G4 and H4 you can dynamically enter up to 3 industries that you want to group and sum.