• 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


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

Sum values of the same date AND based on condition


New Member
How do I sum QTY (pc) that occurs on the same date, and based on whether my customers pay by TRANSFER or CASH (screenshot below).

Thank you so much in advance.

Screen Shot 2019-11-22 at 15.38.35.png


Excel Ninja
Hi ,

Try this in G2 , and copy across and down.

=SUMIFS($C$2:$C$6, $A$2:$A$6, $F2, $D$2:$D$6, SUBSTITUTE(SUBSTITUTE(G$1, "QTY (", ""), ")", ""))



Excel Ninja
One possible like below
... instead of "t" use "TRANSFER" in F-column as well as "CASH" in G-column.
Screenshot 2019-11-22 at 11.06.50.png
Please, next time upload a sample file.

Peter Bartholomew

Well-Known Member

The obvious place for the list of payment methods is the column headers of the output table but other options are possible.
The formula is simply
= SUMIFS( Transactions[Qty], Transactions[Date], Date, Transactions[Tranfer/Cash], PmtType )

The formula is the same whether one uses dynamic arrays, CSE arrays or implicit intersection.
Note: It is also functionally identical to that of @vletm but it exploits structured referencing to produce a readable formula.