Results 1 to 4 of 4

Modified SUMIF

Threaded View

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

    Modified SUMIF

    I am using

    =SUMIF(D:D,"216.*",I:I)
    I am bugged to edit the formula to change 216 to another code
    This is wasting time

    See file attached my n2 to be modified do the sales summing according to codes on column O and then drag down

    To be utilised to arrive to sales by category of stock series
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  2. [SOLVED] See when a workbook was last modified
    By Jiptastic in forum Excel General
    Replies: 3
    Last Post: 03-01-2013, 10:50 AM
  3. [SOLVED] Last Modified
    By Steve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-20-2006, 01:35 PM
  4. modified date
    By ceemo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2005, 02:05 PM
  5. Modified VBA Formula Help!
    By vane0326 in forum Excel General
    Replies: 0
    Last Post: 03-03-2005, 06:29 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