+ Reply to Thread
Results 1 to 2 of 2

Counting Formula

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    13

    Counting Formula

    I've got two columns one recording hours worked on a project in a week and the other giving a running total. E.g column A is hours recorded and Column B is total hours. so in A1 I put 4 and in A2 5. A simple sum formula adds both together to give 9 in cell B2. However cells b3 to b10 also have a figure of 9. Can I in cell b3 say if cell a3 is greater than 0 add it to cell b2?

    Thanks

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Counting Formula

    =if(a2="","",sum($a$1:a1))

+ Reply to Thread

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