tag:blogger.com,1999:blog-2807403883562053852.post529376824440173462..comments2024-03-27T08:40:31.785-06:00Comments on Clayton Cramer.: Any Clever Excel Solution?Clayton Cramerhttp://www.blogger.com/profile/03258083387204776812noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2807403883562053852.post-70640895710115827542018-11-05T20:12:58.288-07:002018-11-05T20:12:58.288-07:00You might consider putting this into a real databa...You might consider putting this into a real database (even microsoft access).<br /><br />The most straight forward way I see to do this in excel is to repeat the weapons columns once. <br /><br />Assuming Farmington in example is row 2, and AG is the first blank column after all your data:<br />formula in AG2 =sum(k2:ac2) // this will give # of weapons used<br />now repeat all weapon columns, AH to AZ (i.e fill-right AH to AZ)<br />formula in ah2 is =if($ag2>1, 0, $h2*k2) // if multi-weapons ->0, else-> num_dead * (0 or 1)<br />this will give num_dead for one weapon, 0 for non-used weapon, and 0 if more than one weapon<br /><br />Fill these down. Sum each column from row 2 to end should give totals by single-weapon-onlyChuckChttps://www.blogger.com/profile/02105142139577885463noreply@blogger.com