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

aparvez007

aparvez007

Member
Hi All,

Please help me in below formula.


I have data in below format.


Product1 in E6 Brand1 in F6 Brand2 in F7

Product2 in E9 Brand1 in F9 Brand2 in F10


data is going till row 238


I want total of (Product1)Brand1 and Brand2

I want total of (Product2)Brand1 and Brand2


I have subtotal in between Product1 and Product2 so no need products total.


Regards,

Pavi
 
@aparvez


Hi


You can use the Formula as


=SUMIFS($E$6:$E$10,$F$6:$F$10,$F$6)


I HOPE IT WILL HELP FULL OTHER WISE TRY TO UPLOAD A SAMPLE WORK BOOK OR GIVE CORRECT EXAMPLE


Thanks


SP
 
Hello sgmpatnaik/Suresh Kumar


Please check below link


http://www10.zippyshare.com/v/14455188/file.html


..


Thanks

Pavi
 
hi,


so you need formula in G238:G239 then just drag it to P238:p239 right?


i will explain how i do this if i were you,


- you need to copy E6 (Product1) to E7 then just color the font to white, do this for all empty column, just copy the Product above


- do this as well in E239 and E242 (copy figure above it and font white)


- then in G238 write down this formula then copy down until G242, then just drag and drop it till P242

=SUMPRODUCT(($E$6:$E$236=$E238)*($F$6:$F$236=$F238)*(G6:G236))
 
@aparvez


Hi


i Tried to Download the file lots of time but i fail


can you upload another link or Upload the file through Drop Box


Thanks


SP
 
Thaks Koi...

But....

I have around 7 different file which i have to do the same excercise.

If you have some other formula which will work faster will be appreciate.


Thanks

Pavi
 
@APARVEZ


HI


sorry


i just download your file due to some work my replay is delay


you are requested to sum the figure with Product and Brand wise in the bottom of your file am i right


then please try the formula in G238 for and drag it to right up to Column N


=SUMIFS(G$6:G$236,$F$6:$F$236,$F$238,$E$6:$E$236,$E$238)


Hope it will Help full other wise please inform


Thanks


SP
 
Hi sgmpatnaik,

Thaks for your reply


sorry for late reply as I reach home just few hours before.


Actually formula didn't work.

plase check file also I put figure what I want.


http://www.2shared.com/file/ROwaevMq/Sumif.html


Thanks

Pavi
 
Hi sgmpatnaik,


Thanks for your kindness.

I will use your formula now but try to find out without adding Product1 & Product2 we will get the same result.


May be Hui or Chandoo can find alternate to this solution.


Thanks once again Mr. Naik for your support.


Thanks

Pavi
 
You must log in or register to reply here.
Back
Top