Oct 15 2021 12:57 PM
Hello All - I am unable to count some values by using CountIFS function with multiple conditions. For example , i want to count aging number that are >15 and <20 with "Not Done"
and In Process Status only. Thanks
Oct 15 2021 01:05 PM
Oct 15 2021 01:12 PM
Oct 15 2021 01:26 PM
Could you provide a small sample workbook without sensitive information?
Oct 16 2021 06:43 AM
@Hans Vogelaar Please see the attach file ,
Oct 16 2021 07:43 AM - edited Oct 16 2021 07:45 AM
SolutionThat's not a very helpful sample, since there is no row with In Process and Aging over 5 days...
I have changed a few cells to get more representative results. See if the attached version does what you wants. or can be modified.
Oct 16 2021 08:03 AM
Oct 16 2021 08:52 AM
You have to use one COUNTIFS with all conditions, as in the version that I attached,
Oct 16 2021 07:43 AM - edited Oct 16 2021 07:45 AM
SolutionThat's not a very helpful sample, since there is no row with In Process and Aging over 5 days...
I have changed a few cells to get more representative results. See if the attached version does what you wants. or can be modified.