No announcements

### Calculation of AverageIF/AverageIFS based on conditions

AverageIF/AverageIFS for Column B & Column D based on the three groups for each sheet in my workbook.
| 1 Replies | 630 Views | Created by SaraPhD - Monday, August 17, 2020 11:12 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Tuesday, August 25, 2020 3:56 PM

### Averageifs statement.

based on certain criteria. The problem I have is that I want to do this based on company name as criteria1 in the averageifs statement. ...
| 2 Replies | 1027 Views | Created by Jono220 - Wednesday, February 13, 2013 5:14 AM | Last reply by David_1234 - Wednesday, February 13, 2013 8:12 AM

### Defining measures based on conditions

null end Then create a new measure based on that calculated column with usage as count of non-empty values. ...
| 2 Replies | 4365 Views | Created by Sengwa - Tuesday, October 27, 2009 6:16 PM | Last reply by Sengwa - Monday, November 2, 2009 7:07 PM

### Filter Tablix based on conditions

Hi Praveen, According to your description, you want to change the rows’ background color based on the column conditions. ...
| 2 Replies | 827 Views | Created by Praveen Rayan D'sa - Friday, July 1, 2016 8:48 AM | Last reply by Xi Jin - Monday, July 4, 2016 8:54 AM

### averageifs with calculated criteria

(\$C\$21:\$C\$710)=11. You'll have to keep on using your original array formula, or add calculated columns to your data that compute the month and year of the dates in column ...
| 2 Replies | 2516 Views | Created by yuri-b - Wednesday, November 23, 2011 10:44 AM | Last reply by yuri-b - Wednesday, November 23, 2011 12:56 PM

### Fields Visible based on conditions

Forms have tabs (pages). You can hide or show form pages based on conditions, there is no such thing as a subform in Outlook. Again, see the information about forms
| 1 Replies | 2642 Views | Created by sly_foxx68 - Thursday, August 25, 2011 3:32 PM | Last reply by Ken Slovak MVP - Thursday, August 25, 2011 6:01 PM

### Make button read only based on conditions

I was wondering how can I make a button read only based on some conditions on a screen. I got 5 buttons on a screen and based ...
| 1 Replies | 1443 Views | Created by jonnagaddala - Thursday, March 15, 2012 11:57 PM | Last reply by J Lamb - Friday, March 16, 2012 1:08 AM

### Column value based on calculation

column value based on a calculation using two other columns.   How do I do this? Is this an SQL ...
| 5 Replies | 5656 Views | Created by Jon Bishop - Thursday, September 11, 2008 10:59 AM | Last reply by Mangal Pardeshi - Thursday, September 11, 2008 11:10 AM

### Calculation based on Column Groups?

Hi artistdedigital, According to your description, you have a matrix in your report and want to do conditional calculation based on the values in column ...
| 3 Replies | 1362 Views | Created by artistdedigital - Thursday, May 22, 2014 5:05 AM | Last reply by artistdedigital - Monday, May 26, 2014 1:13 AM

### Colour Formatting Based on Conditions

I have an issue in trying to format rows base on conditions. Below is a replication of the tables and the select statement. CREATE TABLE ...
| 6 Replies | 736 Views | Created by Yookos - Monday, June 15, 2015 1:34 PM | Last reply by Ricardo Lacerda - Monday, June 15, 2015 6:15 PM

### Calculation based on users selection

- Overwrite the contents of the measure in the calculation script: SCOPE [Measures].[Anz Datum Stand]; SCOPE NONEMPTY([Datum ...
| 9 Replies | 1188 Views | Created by ArnoNym_1234 - Tuesday, March 11, 2014 12:18 PM | Last reply by ArnoNym_1234 - Tuesday, April 1, 2014 5:27 AM

### Calculation based on Dimension Attribute

or any other dimension attribute? The Measure Group has only one measure, which is the count of customers. The calculation would be: SUM(Customer Age)/Customer Count. ...
| 2 Replies | 3110 Views | Created by Max Long - Tuesday, March 6, 2012 5:21 PM | Last reply by AshimM - Tuesday, March 6, 2012 8:41 PM

### records based on date conditions

Try select * from dbo.Employee where StartDate <'20120101' and EndDate >='20120201' In other words, the StartDate should be less than beginning of ...
| 5 Replies | 2535 Views | Created by Piyush Dixit - Tuesday, January 17, 2012 7:31 AM | Last reply by REY - Singh - Sunday, January 22, 2012 9:34 AM

### Sum based on 2 conditions

much as possible and not local dialect.  This is minimal polite behavior on SQL forums. Now we have to do the guessing and typing because you ...
| 4 Replies | 1487 Views | Created by Gilles De Rore - Thursday, December 13, 2012 1:35 PM | Last reply by --CELKO-- - Thursday, December 13, 2012 4:08 PM

### Substring based on few conditions

Large scale of database and data cleansing Remote DBA Services: Improves MS SQL
| 5 Replies | 668 Views | Created by Revathy Menon - Tuesday, August 6, 2019 5:16 AM | Last reply by Jingyang Li - Tuesday, August 6, 2019 3:55 PM

### Calculation based on specific value

In VS2015, I've run into a issue with a calculation that I need some guidance on. Dimensions Account   ...
| 3 Replies | 460 Views | Created by Darren P1 - Thursday, January 18, 2018 7:15 PM | Last reply by willson yuan - Tuesday, January 23, 2018 6:37 AM

### Returning flags based on conditions

Now, once I pass the email,  I need four flags for each role(Buyer,seller,broker,developer) if user has any ...
| 4 Replies | 515 Views | Created by ABC30 - Thursday, June 28, 2018 5:35 AM | Last reply by Visakh16 - Thursday, June 28, 2018 7:05 AM

### Calculate WEEKDAY Based on Two Conditions

Hello, I have to generate a WEEKDAY End Date based on two conditions: "Start Date" and ...
| 1 Replies | 1450 Views | Created by JackSki123 - Monday, March 24, 2014 11:49 AM | Last reply by Nitin gupts - Monday, March 24, 2014 12:13 PM

### Calculation Based on Month Decision

the adjusted value on form2 for month of April. The calculation formula will be as follow for constant value of ...
| 39 Replies | 2219 Views | Created by Albertostin - Friday, December 6, 2013 12:19 PM | Last reply by Albertostin - Wednesday, December 18, 2013 5:23 PM

### Calculation based on Account Range

Hi , I stated my question a little incorrectly.  I want sum of all the Actual Amounts whenever the account range is between 400000 and 899999. Here is what I have ...
| 7 Replies | 5522 Views | Created by KJ007 - Wednesday, March 23, 2011 8:18 PM | Last reply by KJ007 - Monday, March 28, 2011 11:10 PM
• Items 1 to 20 of 2762439 Next ›
No announcements