Results 1 to 4 of 4

sumif with fixed and variable criteria

Threaded View

bufharry sumif with fixed and variable... 12-20-2010, 06:40 PM
shg Re: sumif with fixed and... 12-20-2010, 06:57 PM
TMS Re: sumif with fixed and... 12-20-2010, 07:02 PM
bufharry Re: sumif with fixed and... 12-21-2010, 04:23 AM
  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    5

    sumif with fixed and variable criteria

    I need to sum the result of column “three” when a cell in column “one” is “A” and a cell in column two has either “W”,”X”or”Y”. I have tried using Sumif but have been defeated trying to use the “And” and “OR” to select A and either W,XorY. The result should be 3

    Thanks in advance

    Harry.
    Last edited by bufharry; 12-21-2010 at 04:32 AM.

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