Formula Help, Countifs dependent on drop down selection

%3CLINGO-SUB%20id%3D%22lingo-sub-2926031%22%20slang%3D%22en-US%22%3EFormula%20Help%2C%20Countifs%20dependent%20on%20drop%20down%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2926031%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20want%20to%20count%20days%20absent%20dependent%20on%20the%20category%20of%20absence%20in%20the%20drop-down%20list.%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20if%20sickness%20absence%20selection%20D8%20then%20count%20the%20total%20number%20of%20days%20listed%20in%20K8%20to%20AO8.%20Total%20for%20sickness%20absence%20for%20that%20row%20in%20AP8.%20minus%20columns%20that%20are%20Sat%20or%20Sun%20-%20these%20change%20every%20month%20due%20to%20dates%2C%20that%20last%20bit%20not%20the%20end%20of%20the%20world%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20d9%20is%20DCL%20leave%20then%20it%20would%20be%20totaled%20in%20AQ9%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20makes%20sense%20-%20the%20input%20that%20needs%20counting%20can%20be%20either%201%2C%200.75%2C%200.5%2C%200.25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-11-04.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324189i1098C5C6865E1D9D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-11-04.png%22%20alt%3D%222021-11-04.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2926031%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2928099%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%2C%20Countifs%20dependent%20on%20drop%20down%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2928099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1206767%22%20target%3D%22_blank%22%3E%40KAREN_CARDOW%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIn%20the%20inserted%20link%20you%20will%20find%20formula%20and%20examples.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F4147-excel-sum-based-on-drop-down.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20sum%20values%20based%20on%20selection%20of%20drop-down%20list%20in%20Excel%3F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi I want to count days absent dependent on the category of absence in the drop-down list. 

so if sickness absence selection D8 then count the total number of days listed in K8 to AO8. Total for sickness absence for that row in AP8. minus columns that are Sat or Sun - these change every month due to dates, that last bit not the end of the world 

if d9 is DCL leave then it would be totaled in AQ9 

 

Hope that makes sense - the input that needs counting can be either 1, 0.75, 0.5, 0.25

 

Thank you for your help

 

2021-11-04.png

 

 

 

 

1 Reply

@KAREN_CARDOW 

In the inserted link you will find formula and examples.

How to sum values based on selection of drop-down list in Excel?

 

Hope I was able to help you with this info.

 

 

Nikolino

I know I don't know anything (Socrates)