Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Add a product cost under a specific month column (sumproduct?)

Posted on 2011-02-18
3
Medium Priority
?
265 Views
Last Modified: 2012-05-11
Looking to be able to change the desired month and product value, indicated in yellow and obtain the total cost (value) for the specified product and month.  
Thanks,
JP Add-product-under-specified-mont.xls aa
0
Comment
Question by:easycapital
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 34930441
Hello JP,

Here are two possible ways

=SUMPRODUCT((B3:D3=B9)*(A4:A7=B10),B4:D7)

or

=SUMIF(A4:A7,B10,INDEX(B4:D7,0,MATCH(B9,B3:D3,0)))

Although the latter is longer it's arguably more efficient. Formula 1 needs to be used if there could be more than 1 column with a date header matching B9

regards, barry
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 2000 total points
ID: 34930460
See examples in your sheet, I put one formula in F12 and one in G12 - of course they return the same result......

regards, barry
26832739.xls
0
 

Author Closing Comment

by:easycapital
ID: 34930500
Excellent application!  I favor the sumproduct approach, as it is easier for me to follow.
Thanks!
JP
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question