Hi, I am hoping someone more experienced with Excel can help me create a formula for a sample spreadsheet.
A B
1 03-15-2023 16.33
2 06-15-2023 21.19
3 09-15-2023 10.00
4 12-15-2024 55.00
5 Interest
6 07-15-2023 16.33
7 10-15-2023 21.19
8 01-15-2023 10.00
9 04-15-2024 55.00
I would like to sum all cells from B1 to B9 which have a corresponding year of "2023" in A1 to A9 unless:
the value in B1 to B9 is not numeric
Your help would be appreciated!
A B
1 03-15-2023 16.33
2 06-15-2023 21.19
3 09-15-2023 10.00
4 12-15-2024 55.00
5 Interest
6 07-15-2023 16.33
7 10-15-2023 21.19
8 01-15-2023 10.00
9 04-15-2024 55.00
I would like to sum all cells from B1 to B9 which have a corresponding year of "2023" in A1 to A9 unless:
the value in B1 to B9 is not numeric
Your help would be appreciated!