Greetings,
I hope community members and their loved ones are safe and healthy.
I use the following formula to match and paste values to a different sheet automatically. I am creating automation to help manage my monthly finances.
=SUMIFS('2023_2024_icici_parth'!$H$2:$H$1486, '2023_2024_icici_parth'!$H$2:$H$1486, "> 0", '2023_2024_icici_parth'!$F$2:$F$1486, "Salary", '2023_2024_icici_parth'!$B$2:$B$1486, ">="&'2023_2023_calculations'!C$1, '2023_2024_icici_parth'!$B$2:$B$1486, "<" & '2023_2023_calculations'!D$1)
I have checked the following (and uploaded a sample sheet with data)
- Ensured that the data in columns B, F, and H of the 2023_2024_icici_parth sheet was in the correct format (i.e., dates in column B, text in column F, and numbers in column H).
- Check that the values in cells C1 and D1 of the 2023_2023_calculations sheet are valid and within the range of dates in column B of the 2023_2024_icici_parth sheet.
- Verify that there are rows in the 2023_2024_icici_parth sheet where the value in column F is ?Salary?, and the value in column H is greater than 0.
However, I am still getting 0 as the output.
I used the COUNTIFS to diagnose
=COUNTIFS('2023_2024_icici_parth'!$H$2:$H$1486, ">0", '2023_2024_icici_parth'!$F$2:$F$1486, "Salary", '2023_2024_icici_parth'!$B$2:$B$1486, ">="&'2023_2023_calculations'!C$1, '2023_2024_icici_parth'!$B$2:$B$1486, "<" & '2023_2023_calculations'!D$1)
I am still getting 0
Could I please request assistance from the forum?
Bookmarks