Hi, all,
I'm trying to countif using exact criteria.
A B C
08/08/2017 • x
15/08/2017 • x
22/08/2017 x •
29/08/2017 • x
Year 1
08/08/2017
07/08/2018
I want to count the number of bullets (•) from columns B and C, BUT only when they fall within the date range specified in A7:A8.
Is that possible? Just not finding anything online.
Many, many thanks if you can help. It's driving me nuts.
Edit: the subject is a little misleading as I don't need the resulting value multiplied by another cell....yet!
I'm trying to countif using exact criteria.
A B C
08/08/2017 • x
15/08/2017 • x
22/08/2017 x •
29/08/2017 • x
Year 1
08/08/2017
07/08/2018
I want to count the number of bullets (•) from columns B and C, BUT only when they fall within the date range specified in A7:A8.
Is that possible? Just not finding anything online.
Many, many thanks if you can help. It's driving me nuts.
Edit: the subject is a little misleading as I don't need the resulting value multiplied by another cell....yet!
Last edited: