Results 1 to 6 of 6

A question about the SUMIF worksheet function.

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2008
    Posts
    10

    A question about the SUMIF worksheet function.

    Hi,

    I have two columns, A and B respectively, that contain the following values:
    
    4    "E1-2"
    1    "V2A-1"
    1    "Vm5-5"
    2    "E1-2"
    3    "E1-3"
    1    "E4-11"
    How can I write the SUMIF worksheet function to search for everything in column B that contains the letter "E" and if it contains that letter, it will sum the value in column A?

    Thanks...

    Mike
    Last edited by mbu; 01-30-2008 at 09:53 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