I have an excel workbook with two worksheets Data - raw data and Cover which is my cover sheet.
On the cover worksheet I want to have some values inserted by calculation on data in the data sheet.
1. I need a subtotal of the column COST when the column SEGMENT equals a specific value. That column could have 10 values one being "coscto" lets say I want cell D7 in cover to equal the sum of COST when SEGMENT = "costco"
2. I would also need D9 in COVER to equal the total number of deals when SEGMENT = "costco"
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…