There are several post on FREQUENCY here but I cannot seem to adapt them to my needs. I have several variables that FREQUENCY is tied to and I just cannot make them work. Any help would be greatly appreciated.
~~There are several formulas with frequency on here, but for the life of me I cannot get them to work on my sheets. Mine needs are a little more complex and I am unable to adapt them.
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;">
<col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;">
<col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;">
<col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;">
<col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;">
<col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;">
<col width="64" style="width: 48pt;">
<col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
~~There are several formulas with frequency on here, but for the life of me I cannot get them to work on my sheets. Mine needs are a little more complex and I am unable to adapt them.
Collection Method/ Trap Type | Attractant(s) Used | ID for Collection Location | Trap Pickup Date | Genus | Species | # Females Collected | |||
UV Light Trap | CO2 With Light | S1 | 2/12/2019 | Aedes | vexans | 10 | |||
UV Light Trap | CO2 With Light | S6 | 2/12/2019 | Aedes | sollicitans | 50 | Begin date: | 12-Feb | |
UV Light Trap | CO2 With Light | S1 | 2/12/2019 | Psorophora | ferox | 5 | End date: | 1-Mar | |
UV Light Trap | CO2 With Light | S1 | 2/13/2019 | Aedes | vexans | 2 | |||
UV Light Trap | CO2 With Light | S6 | 2/13/2019 | Aedes | vexans | 4 | Trap Types | ||
UV Light Trap | CO2 With Light | S1 | 2/26/2019 | Aedes | vexans | 6 | New Jersey Trap | | |
UV Light Trap | CO2 With Light | S6 | 2/26/2019 | Aedes | vexans | 8 | UV Light Trap | ||
New Jersey Trap | Light | S1 | 3/1/2019 | Aedes | vexans | 1 | Light Trap | ||
UV Light Trap | CO2 With Light | S1 | 3/1/2019 | Aedes | vexans | 9 | Ovicup/Ovitrap | ||
What I would like to do is count the frequency a trap runs between two dates. There are multiple variables, A (Trap Type), B (Attractants), C (Trap ID) and D (Date). The trap may catch more than one species in a single night and therefore have multiple entries. I need to convert multiple entries on the same date, with the same variables to a "1" and not "15" if I catch 15 different species in a single trap. Above, S1 trap should only read "4" instead of "6", because it only ran on 4 nights with the UV light trap. It should only read "1" if you change the trap type to "New Jersey Trap". I can run the total on mosquitoes captured easily enough with SUMIFS, but FREQUENCY has me whooped (I just don't understand it well enough). | Attractant CO2 With Light Light Octenol | ||||||||
UV Light Trap | |||||||||
Trap site | Nights Run | ||||||||
S1 | ?? | ||||||||
S2 | ?? | ||||||||
S3 | ?? | ||||||||
S4 | ?? | ||||||||
S5 | ?? | ||||||||
S6 | ?? |