Skip navigation
This discussion is archived

With Numbers, how can I mark cells for separate SUMs?

6348 Views 3 Replies Latest reply: Dec 23, 2010 6:13 AM by Holster® RSS
Holster® Level 1 Level 1 (5 points)
Currently Being Moderated
Dec 23, 2010 6:12 AM
Hello

I'm doing a sheet which is totaling up costs for a wedding. Several people are responsible for the costs for various aspects of the event and so I would like to visibly mark cells according to the person, then have a total for each person based on these 'marks'

I want to do it this way so the responsibility for various aspects can be altered easily without changing the organisation of the sheet. People can tell at a glance what parts are theirs.

Is this possible? Can it be done by colour or something similar? Can cells be 'labelled'?

®
PowerBook G4, Mac OS X (10.4.10)
  • WWJD Level 6 Level 6 (15,815 points)
    You might search for threads that include the term "SUMIF" for ideas. Several have been posted that might work for your application.

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.3), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • pw1840 Level 3 Level 3 (840 points)
    Holster,

    Here are a couple of samples for you to look at. The first lists expenses under the column headed by the party responsible for that cost. Each party can readily see his total responsibility. Simple SUM() functions are used for the totals.

    The second uses the "marker" technique you mentioned and the SUMIF() function WWJD suggested. The use of color coding can be nice in this case, but it has some drawbacks if there are many individuals involved in paying the expenses. First, it may be difficult to distinguish similar colors, especially when scattered throughout a long column. And second, It will be necessary to include a conditional rule for each individual or color. You will, however, be able to assign the same rules to the two non-contiguous columns at the same time.

    Formula for Sample 2, Column G: =IF(ISBLANK(E),"",SUMIF(Responsible for cost Marker,F,Amount))

    My opinion is that the first sample is easier to set up and color coding is not necessary as it is in sample 2. However, it's your choice.

    pw

    Mac OS X (10.4.10)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.