• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with a MATCH formula

A

adicaroac

New Member
Hi there,

I would like your help to solve this formula issue. I need to fill cell I6 with the numbers on Column C, if the month on I5 match. For example, if January 2021 (I5) find a January 2021 on column D, then it should populate cell I6 with the number on Column C. So, let' say that D3 is January 2021 and C3 is 5, then on I6 the cell should contain the number 5. Can anyone help me with a formula?
Thank you very much for your help.71829
 
I6: =SUMPRODUCT(($D$3:$D$12>=I$5)*($D$3:$D$12<J$5)*($C$3:$C$12))
copy across

NB: adding an image makes it harder for us to reproduce the problems
To get a quicker, nmore accurate solution make a sample file with the key data you need ie: Column C&D and Rows 5&6
 
You must log in or register to reply here.
Back
Top