Solved

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

Posted on 2011-02-18
3
255 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 500 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 500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

810 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