Results 1 to 10 of 10

Help on correct use of If statement within formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2011
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    5

    Help on correct use of If statement within formula

    Hi I'm pretty new at using excell for more than anything really really simple but I have to put together a spreadsheet in work and I am stuck on what is probably really simple so any help will be really appreciated, I will try to explain it:

    I want to display in a cell a sum but only if in the same row there is a value entered that I need. So for example in cell N17 I want to add Numbers from column K lets say K7 but only if in the same row in Column N7 has Y in it. Does that makes sense in my head its something like if(N7=Ythen+K7)

    Please help

    Thanks
    Attached Files Attached Files
    Last edited by cpyates; 05-07-2011 at 03:07 PM. Reason: poor title

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