• 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.

Excel function help (countif?)

Johnny3000

New Member
Hello dear friends!

I would like to ask you for help with one excel function.

Please see the attached file.

I would like to insert function to "Sheet 1" to column "A" that does this:

If text in cell on the current row from column C is contained in column G (in Sheet 2) then count values from all those rows from column I, that at the same time have value "34340210" in column N.

Thank you very much for ideas!
 

Attachments

  • 20200123 - workfile.xlsx
    25.5 KB · Views: 6
Try......................

In Sheet1, A2 formula copied down :

=COUNTIFS('Sheet 2'!G:G,"*"&C2,'Sheet 2'!I:I,">0",'Sheet 2'!N:N,"34340210")

Regards
 
Hi, thank you for your reply.

Definitely it does something. But I need it to give me sum of the values from the column "I" if the crieteria above is met.
Now it counts only the number of cells that meet the criteria.
Can you please look into it?

regards,
J
 
done
=SUMIFS('Sheet 2'!I:I,'Sheet 2'!G:G,"*"&C2,'Sheet 2'!N:N,"34340210")
 

Attachments

  • 20200123 - workfile_Chris.xlsx
    26.1 KB · Views: 1
Back
Top