Results 1 to 2 of 2

Thread: Need help with a recapitulation formula

  1. #1

    Need help with a recapitulation formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help with an IF formula for recapitulating a spreadsheet as seen below:

    A B C D
    1 O7 1 0
    2 O6 1 1
    3 O6 1 0
    4 O5 3 4
    5 Total 6 5
    6
    7 Recapitulation
    8 O7 1 0
    9 O6 2 1
    10 O5 3 4
    11 Total 6 5

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    120
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    In cell B8 use:

    Code:
    =SUMIF($A$1:$A$4,$A6,B$1:B$4)
    Copy/Autofill down and across to cell C10.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •