Forum Discussion
Solved
Merging Formulas
Hello, How would I combine these two formulas: =COUNTIF(Sheet1$A:$A,"Jan") - I am trying to count all the dates that are in the Jan month column My second formula is below. I believe it need...
As the formula is filtering the results by month, you can apply it to the whole columns. Here is the formula adjusted to catch the entire columns B and D.
=((SUMIFS( Sheet1!B:B, Sheet1!B:B, ">="&DATE(2023, 1, 1), Sheet1!B:B, "<="&DATE(2023, 1, 31) ))-(SUMIFS( Sheet1!D:D, Sheet1!B:B, ">="&DATE(2023, 1, 1), Sheet1!B:B, "<="&DATE(2023, 1, 31) )))/B2I just tested it with 400+ results for January, and it works fine:
If you need anything else, let me know.
Is there a way to make the formula show indefinite values? for example this is need to track the number of service requests and we could have 10 per month or 100 per month.
As the formula is filtering the results by month, you can apply it to the whole columns. Here is the formula adjusted to catch the entire columns B and D.
=((SUMIFS(
Sheet1!B:B, Sheet1!B:B, ">="&DATE(2023, 1, 1), Sheet1!B:B, "<="&DATE(2023, 1, 31)
))-(SUMIFS(
Sheet1!D:D, Sheet1!B:B, ">="&DATE(2023, 1, 1), Sheet1!B:B, "<="&DATE(2023, 1, 31)
)))/B2
I just tested it with 400+ results for January, and it works fine:
If you need anything else, let me know.
- Thank you so much!!