This discussion is archived
6348 Views 3 Replies Latest reply: Dec 23, 2010 6:13 AM by Holster®
Currently Being ModeratedDec 23, 2010 6:12 AM (in response to Holster®)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)
Currently Being ModeratedDec 23, 2010 6:12 AM (in response to Holster®)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.
pwMac OS X (10.4.10)
Currently Being ModeratedDec 23, 2010 6:13 AM (in response to Holster®)This is great guys, thanks so much for your advice.
I have it working now, I used the SUMIF function and created a new column for the initials of the responsible party as suggested.
Works like a charm!
®PowerBook G4, Mac OS X (10.4.10)