Results 1 to 4 of 4

if two columns have same value, return the value from another cell if it meets a condition

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    New York, US
    MS-Off Ver
    Excel 2010
    Posts
    43

    if two columns have same value, return the value from another cell if it meets a condition

    i want to check if,

    column J in BW Draw tab = column L in BW Complaints tab

    if they do equal, then sum all of the instances of column M in the BW Complaints tab if it equals the value in M4 in the BW Draw tab.

    i basically would like to have a breakdown of the data that is in L5 where it says 16, and have that data broken down by code type in the purple row

    any help, i would really appreciate
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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