Forum Discussion
COUNTIF, but more complicated
Hello, thank you everyone for your help. I have 2 columns, a date on the left cell, the payment $ on the right cell, and the column is long, goes down many cells, with the same pattern. I need to mak...
=SUMPRODUCT((YEAR($B$10:$B$27)=B2)*$C$10:$C$27)You can try SUMPRODUCT.
There is a button which i can click to choose which screenshots i want to upload.