Results 1 to 4 of 4

Addition Formula

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2008
    Location
    RI
    Posts
    16

    Addition Formula

    I am a new excel user. I a trying to write a certain formula but am having trouble. I searched this site and looked in the "Excel For Dummies" book that I have, but can't seem to find the help I need.

    I want to write the formula to add a column of numbers, say H-10 through H-15. Each cell will have a number in it, but I want only to add the cells if the cell precedding it in the G-10 through G-15 Collumn is blank. For example if cells G-12 and G-14 have an "X" in them, then I do not want Cells H-12 and H-14 to be added. I only want the formula to add cells H-10,H-11,H-13, and H-15. I used just 6 cells for example, the column of cells to be added will be a lot longer.

    Thanks
    Last edited by oldchippy; 11-09-2008 at 12:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1