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

Can we sum two different Row with one sum function [SOLVED]

@Apple


Hi


i can't understand what you are going to achieve because there is not much information about your formula


first i would like to remind once again please read the 3 sticky Green Key before posting


http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


now coming to point about your Question


=SUMIF($G:$G,$A3,H:H)+SUMIF($G:$G,$A3,I:I)


i think the formula should be like this


=SUMIFS($G:$G,$H:$H,$A3)+SUMIFS($G:$G,$I:$I,$A3)


or


=SUMIFS($G:$G,$H:$H,$I:$I,$A3)


Hope it will give some idea about the formula other wise please give some more details and it is better to upload a sample file using with the link: - http://chandoo.org/forums/topic/posting-a-sample-workbook


Hope You Understand


Thanks


SP
 
Category Amt Amt

sweet 100 35

Cookies 35 100

sweet 35 400

Cookies 500 90

Hi,

I want to sum both amt with single sumif/sumifs


Eg:

sweet 570

Cookies 725
 
@Apple


Hi


Say your data stores from Column A:C


Column A has Category and Column B & C has Qty and you place a helper Category in D1 & D2


write down the formula in E1 as


SUMIFS


E1 = SUMIFS(B:B,A:A,$D1)+SUMIFS(C:C,A:A,$D1) and drag Down


exp.


https://dl.dropboxusercontent.com/u/75654703/Apple.xlsx

[pre]
Code: 
sweet	100	35	100		SUMIFS			SUMPRODUCT
cookies	35	100	200		sweet	570		970
sweet	35	400	300		cookies	725		1325
cookies	500	90	400
[/pre]

SUMPRODUCT


=SUMPRODUCT((A:A=$D1)*(B:D))


Hope you solve your problem other wise please inform us


Thanks


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