Conditional Sum

[wsr429]

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!

 

[BrianM45]

Hi wsr429

Why do you want to sum values in text format, Excel does not know how to do it, already transform your data into numerical values

Then, you can use SUMIFS()

 

[fjns]

Hi, see the linked file for a possible solution...

The formula used in the table:
=SUMIFS(B:B,A:A,">="&DATE(F2,1,1),A:A,"<="&DATE(F2,12,31))

CondSum.xlsx

 

[wsr429]

@BrianM45 – Sorry, I meant to have “Interest” in B6

@fjns – Thanks so much for posting a formula for me. It works great. I really appreciate it!

 

[fjns]

Hi, I am very glad that the formula works.
If I have enough knowledge, I am happy to help at any time.