restaurant pos computer systems

Excel SUMIF? Question: Want to add descriptions together into one column based off of criteria (10,000 lines)?

Jun 16, 2010 by | Posted in Software

Example in the first column is the criteria and in the second column what I want to sum.

Note: the "_" I used to just hold my spacing because yahoo would not.

Currently my data looks like this:

Column

I believe you are trying to combine the lines for each vendor into one line incorporating all individual elements. So, in your example, the result in Row 1 would be:

1st Class Solutions, Inc - Computer based training software, Education

garbo7441 | Jun 16, 2010

  • What's hot

    Belkin BE108200-06 8 Outlet Home/Office Surge Protector with Telephone Protection
    CE (Belkin Components)


    List Price: $31.99
    Price: $13.19
    You Save: $18.80 (59%)

    • Outlets include sliding safety covers; detachable cord-management clip for cable organization
    • Right-angle plug keeps cord close to the wall
    • Belkin Lifetime Warranty and $200,000 Connected Equipment Warranty
    Belkin 8-Outlet Home/Office Surge Protector with Phone/Coaxial Protection and Extended Cord
    CE (Belkin Components)


    List Price: $39.99
    Price: $3.99
    You Save: $36.00 (90%)

    • Outlets include sliding safety covers; detachable cord-management clip for cable organization
    • Belkin Lifetime Warranty and $200,000 Connected Equipment Warranty
    • 8-outlet surge protector with extra-long 12-foot cord
    Pioneer DEH-3300UB CD Receiver with iPod Direct Control and USB Input
    Car Audio or Theater (Pioneer Mobile)


    Pioneer Mobile

    List Price: $100.00
    Price: Too low to display


    • 4 x 50W MOSFET amplifier with one RCA preamp output (2V)
    • Single-DIN AM/FM radio, CD, CD-R/RW, MP3/WMA/WAV, USB, iPod/iPhone receiver
    • Detachable faceplate with 10-character LCD display, red key illumination
    Pioneer DEH-6300UB CD Receiver with iPod/iPhone Control, Pandora player and MultiColor LCD
    Car Audio or Theater (Pioneer Mobile)


    Pioneer Mobile

    List Price: $150.00
    Price: Too low to display


    • Detachable faceplate with two-line LCD display; separate customizable illumination for keys/display
    • Advanced Sound Retriever restores audio from compressed digital recordings
    • Single-DIN AM/FM radio, CD, CD-R/RW, MP3/WMA/WAV, USB, iPod/iPhone receiver

Advanced Computer Solutions Group

www.advancedcsg.net