Results 1 to 11 of 11

Search Row for 2 Matches and Sum Collumn Below

Threaded View

  1. 10-07-2021, 03:54 PM #1
    djc123
    djc123 is offline
    Registered User
    Join Date
    12-18-2018
    Location
    Phuket, Thailand
    MS-Off Ver
    Windows 11 - MS Office 365
    Posts
    88

    Search Row for 2 Matches and Sum Collumn Below

    Hi guys and gals,

    I have a PL that lists the 12 months of the year and the year itself.

    I want a formula that uses these values and searches Row1 in Revenue! and then returns the sum of the values below.

    I have made some notes in blue and given an example on the sheet attached.

    Thank you so much!

    Danny
    Attached Files Attached Files
    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. Creating a collumn based on a diffrent collumn with a formula applied
    By codgas in forum Tips and Tutorials
    Replies: 2
    Last Post: 06-15-2018, 11:43 AM
  2. search 2 criteria and if it matches give me the number of matches
    By sxch12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2017, 03:16 PM
  3. [SOLVED] How Can I: Search a Collumn in Other Document for Partial Text?
    By Sandcastle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2015, 11:33 AM
  4. Search a table with multiple search inputs and return all matches
    By JDI in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-16-2014, 12:23 PM
  5. [SOLVED] Find a collumn in a dynamic sheet and select the entire collumn
    By Armand0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 11:20 AM
  6. Search two LISTS (columns A and B) to find common matches (which may not be EXACT matches)
    By zonggu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2012, 03:25 PM
  7. search for non empty cells in a collumn and put a border on top
    By websqa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2005, 06:01 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1