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

Sum values of the same date AND based on condition

ko1

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
 

NARAYANK991

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 (", ""), ")", ""))

Narayan
 

vletm

Excel Ninja
ko1
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
64102

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