+ Reply to Thread
Results 1 to 3 of 3

SUMIF wildcard , doing manually 300 times will take long

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    SUMIF wildcard , doing manually 300 times will take long

    I have this on cell b1

    =sumif(sheet1!a:a,"100.*",sheet1!m:m)

    If i drag down i have to edit the formula on b2 to wildcard 101 while 101 is on cell a2

    Maybe some and formula to tune up this automatically

    The series of codes are running numbers as follows on a1 going upto 300

    100
    101
    102

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: SUMIF wildcard , doing manually 300 times will take long

    If you have the codes in column A can't you take use them for the wildcard?
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: SUMIF wildcard , doing manually 300 times will take long

    Yes that the AND i was looking for , you saved me from doing it for 300 times , Thanks Norie

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] =IF and =SUMIF formulas creating long long long data processing times.
    By comp in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-26-2014, 02:59 PM
  2. Transposing a column hundreds of times without doing it manually
    By Mathias8337 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-17-2012, 08:16 AM
  3. [SOLVED] Wildcard with sumif
    By fractallinda in forum Excel General
    Replies: 8
    Last Post: 02-27-2006, 07:15 PM
  4. Sumif using wildcard
    By claireanddoug in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2005, 06:05 PM
  5. [SOLVED] Wildcard MATCH() breaks on long (?) strings
    By [email protected] in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2005, 10:06 PM

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