Results 1 to 3 of 3

Sum up value according to criteria

Threaded View

  1. 08-26-2016, 08:47 AM #1
    andy_tap
    andy_tap is offline
    Registered User
    Join Date
    04-08-2014
    Location
    Oz
    MS-Off Ver
    Excel 2013
    Posts
    63

    Sum up value according to criteria

    Hi,

    Can a formula add up values according to meeting criteria?

    I have examples on the attached spreadsheet to demonstrate requirements. Would maybe IF/AND/OR work here?

    Thanks

    Andy
    Last edited by andy_tap; 08-26-2016 at 12:58 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting cells that meet multiple single criteria as variable criteria
    By BillBasil in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2016, 10:33 AM
  2. [SOLVED] Add criteria to existing formula and skip blanks if criteria not met and move to next cell
    By sprewett in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-07-2014, 09:48 AM
  3. [SOLVED] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  4. [SOLVED] If 2 criteria are met, total 1 matching range of criteria & paste to columns on 2nd sheet
    By Terri H in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2013, 07:41 PM
  5. [SOLVED] Find a number closest to 30 in a range with one more criteria (criteria includes text)
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2013, 01:16 PM
  6. Macro to search for a criteria and begin copying data into a new sheet based on criteria
    By balston2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  7. [SOLVED] create drop down box to select multiple criteria and link macro to each criteria
    By anand_erin in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-03-2012, 06:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1