Forum Discussion
jbtm
Nov 15, 2024Copper Contributor
Date and countifs formulas not working
Hi! I am trying to use two formulas, and neither are returning the values they should. FORMULA 1 The first formula should be inputting a value based on a date range. I want the cell to say CO16 ...
SergeiBaklan
Nov 16, 2024Diamond Contributor
As variant if Formula2 you may use result of Formula1
=COUNTIFS( L:L, Q$2, S:S, $P3 )