+ Reply to Thread
Results 1 to 9 of 9

Counting products based on Invoice Number and Multiple Products on same column

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Arizona
    MS-Off Ver
    Office 365
    Posts
    2

    Counting products based on Invoice Number and Multiple Products on same column

    Good Morning,

    I am having a hard time figuring out a formula that will give me a count on certain products on a invoice. I normally try to do my best to research but I do not know where to begin to look.

    Each morning I run a report and manually count cell phone activations by Data plan to add into my MTD Report for our sales reps. This is a very time consuming process and I would like to find a more efficient way of adding up activations.

    Here is how the report is laid out. I'm trying to figure out how to total up activations by data plan (smart, unlimited plan). If a invoice contains "activation rebate sku" and "unlimited plan" the formula would return a total for unlimited plans.

    Is this something that can be done?

    Report_Capture.JPG

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Counting products based on Invoice Number and Multiple Products on same column

    Welcome to the forum.
    Yeah so I would use a pivot table and possibly a helper column, and you will be amazed how much faster this is than manually doing it.



    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Counting products based on Invoice Number and Multiple Products on same column

    Hi, welcome to the forum

    Take a look at using SUMIFS() for this. If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Counting products based on Invoice Number and Multiple Products on same column

    Quote Originally Posted by FDibbins View Post
    Hi, welcome to the forum

    Take a look at using SUMIFS() for this. If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    or COUNTIFS is what I was thinking, but I would rather have a pivot... :D

  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    Arizona
    MS-Off Ver
    Office 365
    Posts
    2
    Quote Originally Posted by mikeTRON View Post
    or COUNTIFS is what I was thinking, but I would rather have a pivot... :D
    Thank you both for your replies! I'll take a look at both options and see how far I can get. Thank you for the welcome and the help!

  6. #6
    Registered User
    Join Date
    06-16-2016
    Location
    United States
    MS-Off Ver
    2007
    Posts
    5

    Re: Counting products based on Invoice Number and Multiple Products on same column

    This is exactly what i was looking for

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Counting products based on Invoice Number and Multiple Products on same column

    You probably used COUNTIFS? Im happy you got your answer

  8. #8
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Counting products based on Invoice Number and Multiple Products on same column

    Quote Originally Posted by FDibbins View Post
    You probably used COUNTIFS? Im happy you got your answer
    The response you are responding to is actually not the OP, so we don't know if a1mobile solved the problem yet... maybe they just melted as Arizona is entirely too hot. image.jpg

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Counting products based on Invoice Number and Multiple Products on same column

    haha yup, I didnt see a new member replying

+ 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. Replies: 6
    Last Post: 03-05-2016, 02:42 PM
  2. Counting mixed orders with different products
    By DRUMMASTER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2015, 07:40 PM
  3. Formula to work out how many products among various products!
    By MissConfussed in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-02-2013, 02:24 PM
  4. One invoice, Multiple products, how do I show it on Excel?
    By asar_k in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-27-2012, 11:24 AM
  5. [SOLVED] Not counting all types of products
    By BBoyAl in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-01-2012, 03:47 PM
  6. Counting Products Sold Per Rep
    By ems.payroll in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-27-2008, 03:06 PM
  7. Counting products delivered by month
    By gdi2k in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2007, 08:50 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.27277 seconds
  • Memory Usage 9,110KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (3)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (9)memberaction_dropdown
  • (1)navbar
  • (3)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (9)postbit_legacy
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1