+ Reply to Thread
Results 1 to 2 of 2

Querry Range and Add

  1. #1
    Sandy
    Guest

    Querry Range and Add

    Hello
    My spreadsheet has a variable number of columns from row 19:378. I would
    like to search the range for the contents of c384, and whenthe criteria is
    met add the cellst he 'found' cell. It doesnt matter whether this is
    accomplished by formula or code.
    Example:

    A19=Cat B19=Cat
    A20=10 B20=40

    The criteria is Cat found in C384 and the total would be 50 or the total of
    all occurences in the range where cat is found.

    Im not sure if I have explained adequately or not but I am having a hard
    time getting stated on this one.
    Thanks!



  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    I'm not 100% sure what you mean but it sounds as though you could use a SUMIF worksheet function.

    For your small example:

    =SUMIF(A19:B19,C384,A20:B20)

+ 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