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

How to sum values based on Voucher no. when it's not repeating?

Bipin619

Member
Dear Experts,

PFA enclosed herewith. Is there any formula to get desired result? It's cumbersome process to sum each voucher manually.
 

Attachments

  • How to sum based on vch no..xlsx
    9.6 KB · Views: 20
Hi bosco_yip,

I'm curious about this formula, because I don't quite understand how it works. It appears the first segment to comprise the logical argument using the * are acting like an AND function, whereas I'm not sure what the + is doing in that segment. Also, would you mind explaining why you use the 1/ in the iferror fomula?

Thanks!


Try,

In E2, copied down :

=IF((A3<>"")*(C2<>"")+(C3=""),IFERROR(1/(1/(SUM(D$2:D2)-SUM(E$1:E1))),""),"")

Regards
Bosco
 
Back
Top