condiational sum

  1. F

    Condition Report By Pivot table

    CLIENT SALES DATA CLIENTS DATE SALES AMOUNT CLIENT 4 10-Feb-24 819 CLIENT 4 10-Feb-24 326 CLIENT 4 10-Feb-24 952 CLIENT 3 10-Feb-24 210 CLIENT 3 10-Feb-24 820 CLIENT 3 10-Feb-24 809 CLIENT 3 10-Feb-24 298 CLIENT 2 10-Feb-24 728 CLIENT 2 10-Feb-24 772 CLIENT 2...
  2. R

    Add 1 employee after every 100 client

    How can I add new Account manager after every 100 New client/New logo sale and add Engineer after every 80 New client/New logo sale. Customer Count Jan Feb Mar Apr May Jun Jul Aug Booked Revenue 36,299 58,039 40,913 48,523 51,007 52,337 50,968 50,938 ARPU 4,000 5000 5000 5000 5000...
  3. G

    Get value from Nth row convert value and paste result in different sheet

    Hello, I have created an excel file where employees can create projects and follow an introduction process. I want to get the summarized then converted to one cell as green red or yellow. The status bar moves every 17th row. i want to go to the row get the data from x columns then from y...
  4. T

    If statement with conditions

    Hello, I'm trying to do an IF statement formula but I have too many arguments. My goal is to assign a numeric value in cell C3 based on conditions met or not met in C2 and C1. For example, as shown if table below --- if income is between $24,600 - $49,200 and the family size is 4 or fewer...
  5. SemperFi

    Adding Several Logical Conditions

    Hello Team, I need to be able to add several IF statement logical conditions: If C4<=20% then is 20 If D4<=1.07% then is 20 If E4>=75% then is 20 I need to be able to add the "20" for each value if is true, in the sample all are true, the answer should be 60, if only two are true then the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top