Hi everyone, I really need some help as my brain has popped!
I have a spreadsheet with three tabs. One is a dashboard to bring together values from the other two. The purpose is to calculate the quantity of items per county so I can determine volumes needed for storage.
The sheets are...
Hi,
I need a formula that will allow me to count the number of account Approved or Active between a date range
A B
Active 1/01/19
Approved 1/19/19
Active 2/10/19
Pending 2/20/19
Close 3/15/19
Thanks,
Carlos
I need a formula that will help me rank the 'Jan Var. for rank only' values, ignoring blanks in between rows, in ascending order. So the largest negative will get rank 1, etc. Then if the values in that column are the same, I want to break the tie by looking at which row has the larger number of...
So, the goal is to find 3 criteria within column D, if column P ( month ) matchs another column on a different tab, count the number on column J
The old formula that was used is, "=IFERROR(IF(OR($C5923="Renewal",$C5923="Client Implementation"),0,J5923),"-")" since our CRM has been updated...
I hope you can help
I am running out of time and I am trying to run a formula which provides a count based on 2 types of criteria Year (Column A) & Type (Column S - which is a multiple pick list option)
I have tried
=COUNTIFS('SALES'!A2:A100,2012,'SALES'!S2:S100,"*Family*")...
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.