+ Reply to Thread
Results 1 to 4 of 4

Invoice Log - Formaula Help

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    UK
    MS-Off Ver
    365
    Posts
    14

    Invoice Log - Formaula Help

    Hi all

    I need some help with adding/creating a formula to my invoice log and any help would be hugely appreciated.

    From A6 to A17 I have the months of the year in order of our financial year (March - February).

    From A23 down, I will be inserting invoice data. Each row will contain a Date (e.g. 15/03/2017) and a Price amongst other things and I need to aggregate the price values for all rows and show that aggregated price value next to the months (B6-B17) so we can see easily how much income we are expecting to invoice for each month.

    I have attached the screenshot of that area of the invoice log.



    Any offers of help would be hugely appreciated.

    Thanks
    Kris
    Attached Images Attached Images
    Last edited by kriscons; 03-15-2017 at 08:11 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Invoice Log - Formaula Help

    Hi,

    I think a SUMIFS formula will work for you.

    Something like this:

    Please Login or Register  to view this content.
    The end of it is for the criteria in column B.

    Attached is an example.

    Hope this makes sense and is helpful.

    Cheers
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-15-2017
    Location
    UK
    MS-Off Ver
    365
    Posts
    14

    Re: Invoice Log - Formaula Help

    Thank you, thats really helpful.

  4. #4
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Invoice Log - Formaula Help

    You are very welcome. Glad I could be of some assistance.

    Cheers

+ 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: 4
    Last Post: 01-09-2017, 10:56 AM
  2. Looking for a formaula that will look up a food cycle
    By dinoo1 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-08-2017, 08:13 PM
  3. Formaula to convert data
    By aakhan2011 in forum Excel General
    Replies: 7
    Last Post: 07-09-2014, 01:30 PM
  4. formaula problem
    By lsapp289 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 03:07 AM
  5. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  6. Excel Formaula
    By timmycl_7 in forum Excel General
    Replies: 1
    Last Post: 06-11-2008, 07:08 AM
  7. [SOLVED] Formaula to multiply and add
    By Frank Malone in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2006, 05:55 AM

Tags for this Thread

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