Forum

I got it with an index/sumproduct, since sumproduct can handle arrays. =INDEX(Values[Vol/hr],SUMPRODUCT((([@Nozzle]=Values[Nozzle])*([@Bar]=Values[...

I'm confused by what you are wanting, are you wanting 2 formulas? It would be easier to visualize if you can upload your expected result in your works...

If I am understanding you correctly, it sounds like you don't want a calculation performed if a cell is blank? If that is the case, a simple IF statem...

I don't know much about Power Bi except what I have seen on YouTube, but my understanding is Power Bi uses the same Power Query so I would think so; y...

Take it up to Power Query, unpivot the year columns, to come up with "year due" and "amount" columns, then, from there you can load them to pivot tabl...

Glad to help! I'm glad Phil was able to fill in the gaps that I wasn't able to explain clearly. Good luck on your project and happy Excel-ling! 🙂

Please upload a sample of your worksheet, you will get better and more concise help if we can see and manipulate the work you have.

There are a couple of ways to go about this, a nested IF or IFS, but I would recommend a VLOOKUP. You would simply put the formula =VLOOKUP(value,tblL...

Like this?

Without looking at your dashboard I have a couple of thoughts. First, if your dashboard is driven by formulas, a simple change to your formula may do ...

I'm sorry but I don't understand your explanation of the issue. Please upload an anonymized sample of your worksheet showing what the issue is and wha...

In this case, it would be helpful if we could see a sample of the file so we can look at the settings of your pivot tables.

It's always easier to help when a workbook is attached over a picture, but have you used #? Something like =SUMIF(B4#,1,$E$4:$I$17) I believe is the s...

You could also do it using Power Query. See attached.

Mynda, that's so cool, I never knew it was a possibility! Do you have that demonstration as a video topic in the future?