mix

Hi, Does anyone have a quick or easy way to make two stacked bar charts right next to each other? I have multiple chart elements that I am using and they can either all be independent or stacked, but I cannot do a mix. I am using my work computer and am unable to install any special software to...

Hi I want an example when mixed cell reference is needed. for example A$1 or $A1. in all examples I am seeing so far, using $A$1 instead of A$1 or $A1 can fix the issue as well. then I am wondering why need the mix when $A$1 can be used, the link below is one of the examples i have seen so far...

formulas fail to sum correctly. I have googled and checked all suggestions found to no avail. I suspect it is due to a mix of text vs. numbers within formulas that create the numbers to be summed. here is one of the formulas: =IF(AND($B63="u",$C63="w"),IF(V63="rns",1.25,IF(V63="c",0,0)),"")...

I know there's an easy way to do this, but I can't figure it out. I need sumproduct to work on two different data sets vertically. I usually do them where the criteria and data are in separate columns. I've put a simplified example below. I'm getting tired of doing the formula I've been...

Hello, I am usually not too bad with Excel, but I can't figure out this. Here is the issue I am facing. I have a very large set of data, with many different fields. In short, it shows all unique sales to customers with countries, product lines, month and other variables. I have done a pivot...

I'm new as a member to this forum but have admired the contributions from members for some time as a reader. I have a question on Price, Volume and Mix (PVM) calculations with the nuance regarding introduction of a 0 (Zero) into the analysis. Most of the PVM analysis and the corresponding...

Hi everybody, This should be an easy for everyone that know <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>...