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

Sumif or sumifs using column and rows

M

melvin

Member
Folks,

Would someone please assist with a sumif or sumifs or any appropriate formula.

Thanks

Regards,

Melv.
 

Attachments

  • Sumif rows & column.xlsx
    17.2 KB · Views: 3
Hi,

You should probably elaborate a bit on what exactly you need, because your post is not that specific and the attached file doesn't help that much either.

Best,
Nuno
 
Hi Melv,

Not much difference in your both sheets, both having only 3 rows (same data).
=SUMIF(Data!$C$2:$C$4,B5,Data!$E$2:$E$4)

Regards,
 
If what you need is to populate column C of sheet "Sheet1" with the sum of values in column E of sheet "Data", based on the information of columns A and B of sheet "Sheet1" and on the Week selected in the yellow cell, try this in cell C5:

=SUMIFS(Data!$E$2:$E$4;Data!$B$2:$B$4;Sheet1!A5;Data!$C$2:$C$4;Sheet1!B5;Data!$D$2:$D$4;Sheet1!$A$1)

(you'll probably need to replace the ";" of my formula with ",")
 
You must log in or register to reply here.
Back
Top