Results 1 to 7 of 7

multipling on multiplea critera

Threaded View

tabkaz multipling on multiplea... 05-21-2016, 07:01 AM
oeldere Re: multipling on multiplea... 05-21-2016, 07:15 AM
tabkaz Re: multipling on multiplea... 05-21-2016, 07:18 AM
Tony Valko Re: multipling on multiplea... 05-21-2016, 07:24 AM
etaf Re: multipling on multiplea... 05-21-2016, 07:17 AM
tabkaz Re: multipling on multiplea... 05-21-2016, 07:20 AM
forestview Re: multipling on multiplea... 05-21-2016, 07:26 AM
  1. #1
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    65

    multipling on multiplea critera

    Trying to work on formula based on looking for month and then multiply by values in adjacent cell, currently using the following formula but it has too many arguments and cant be updated if new month is added.

    tried sum product but couldn't generate a workable formula. therefore need help in nesting this formula or any other way to calculate.

    =IF(B2=N$2,A2*P$2,IF(B2=N$3,A2*P$3,IF(B2=N$4,A2*P$4,IF(B2=N$5,A2*P$5,IF(B2=N$6,A2*P$6)))))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIFS (Several Critera)
    By mackan7695 in forum Excel General
    Replies: 5
    Last Post: 09-15-2015, 03:24 AM
  2. Autofilter Critera
    By 13lack13lade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2013, 02:46 PM
  3. [SOLVED] SUMIFS with <> Critera
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2013, 01:35 PM
  4. [SOLVED] Dividing and Multipling
    By amanp786 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2013, 10:35 AM
  5. Count with two critera
    By mwrfsu in forum Excel General
    Replies: 2
    Last Post: 08-01-2007, 09:14 PM
  6. Multipling the value of 3 text boxes
    By Amber_D_Laws in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-20-2006, 10:45 AM
  7. How do I sum with two critera?
    By Clare in forum Excel General
    Replies: 4
    Last Post: 08-24-2005, 10:05 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