Results 1 to 19 of 19

help to Make the function shorter and easier

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2020
    Location
    egypt
    MS-Off Ver
    2013
    Posts
    9

    help to Make the function shorter and easier

    hello everyone from Egypt

    kindly i need your support and help to Make the function shorter and easier , below function working good but i believe that other way to be more easier


    "&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$8="feb",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$9="Mar",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$10="Apr",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$11="May",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$12="Jun",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$13="Jul",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$14="Aug",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$15="Sep",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$16="Oct",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$17="nov",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    +IF(T$18="Dec",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
    Last edited by waelwilliam; 03-30-2020 at 08:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Make Fomrula Shorter..
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-12-2017, 12:27 PM
  2. make 2 vba shorter and more compact
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2017, 02:39 PM
  3. COUNTIFS function makes excel slow, how to make the function "shorter"
    By Gifupack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2015, 07:01 AM
  4. How to make this formula shorter
    By PatrikIden in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2015, 06:57 AM
  5. [SOLVED] How can I make this code shorter by using a loop. or there's any easier shorcuts code
    By romarkevinruiz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-10-2014, 08:53 AM
  6. Make VBA code shorter
    By juanrmz24 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2013, 12:11 PM
  7. Improve Excel Help Text - Make easier to Find Function Refs
    By RichardAllen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-10-2006, 01:00 AM

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