Message:

<p>[QUOTE=&quot;charlienorth, post: 781315, member: 20809&quot;] </p><p><br /></p><p><br /></p><p><span style="color: black"><font face="Verdana">I had to load the conditional sum add-in but it works like a charm.&nbsp; Thank you</font></span></p><p><br /></p><p><span style="color: black"><font face="Verdana">Well, I ended up having to find this formula so that I was getting the number of occurences rather than a sum each value:</font></span></p><p><span style="color: black"><font face="Verdana">&nbsp; </font></span></p><p><span style="color: black"><font face="Verdana">=COUNTIF(E1:E100,&quot;14&quot;) </font></span></p><p><br /></p><p><span style="color: black"><font face="Verdana"> (Where the E column is the size column.&nbsp; The 14 is changed for each size 14mm through 40 mm.)</font></span></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><span style="color: black"><font face="Verdana">Thanks Doug, I think I have it.&nbsp; I never used a spreadsheet before but it seems needed for the coin collecting thing.&nbsp; <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie1" alt=":)" unselectable="on" unselectable="on" /></font></span>[/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in