1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Sum Multiple Criteria Same Cell

    From leonard hofstatder@21:1/5 to All on Tue Nov 15 05:48:52 2022
    Seems easy enough, HA!


    Cell A1/A2 =(multiple invoice amounts for the same check)

    _______________
    $19.95
    $0 - refused
    $1163.22
    $489.88
    _______________

    $1331.75
    $37.90
    $37.90
    $130.29
    _______________


    Cell B1/B2 =(calculate sum for A1)



    Thank you, big(ger) brains!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)