Good Day,
I'm trying to get this formula to work where it searches completed dates within a range of dates then if the value is true runs a countif to check how many customers are within that range.
Any assistance would be appreciated.
Example below:
I'm trying to get this formula to work where it searches completed dates within a range of dates then if the value is true runs a countif to check how many customers are within that range.
Any assistance would be appreciated.
Example below:
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Completed Date | Customer Code | |||||||
2 | 1/25/2022 | CLICKZGRP | |||||||
3 | 5/7/2022 | CASHBZGRP | Date Ranges | ||||||
4 | 11/5/2022 | CLICKZGRP | 1/1/2022 | 31/1/2022 | |||||
5 | 2/23/2022 | SRITEZGRP | |||||||
6 | 5/7/2022 | CLICKZGRP | Completed Sites | Expected Values | |||||
7 | 4/7/2022 | SRITEZGRP | CLICKZGRP | 0 | 1 | ||||
8 | SRITEZGRP | CASHBZGRP | 0 | 0 | |||||
9 | PNPZGRP | SRITEZGRP | 0 | 0 | |||||
10 | 1/25/2022 | PNPZGRP | PNPZGRP | 0 | 1 | ||||
11 | SPECIZGRP | SPECIZGRP | 0 | 1 | |||||
12 | 1/12/2022 | SPECIZGRP | |||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E7:E11 | E7 | =IF(AND(A:A>$D$4,A:A<E4),COUNTIF(B:B,D7),0) |