I need dates I add into a cell to have a value of 25 and then for them to total in another cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-2692902%22%20slang%3D%22en-US%22%3EI%20need%20dates%20I%20add%20into%20a%20cell%20to%20have%20a%20value%20of%2025%20and%20then%20for%20them%20to%20total%20in%20another%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692902%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20to%20charge%20everyone%20who%20is%20locked%20out%2025%20dollars.%20I%20have%20to%20keep%20track%20of%20the%20dates%20to%20go%20back%20and%20verify%20with%20camera%20footage.%20Therefor%20I%20need%20my%20cells%20with%20dates%20in%20them%20to%20each%20have%20a%20value%20of%20%2425%20and%20then%20I%20will%20add%20the%20values%20of%20the%20dates%20for%20each%20person%20(if%20there%20is%20more%20than%20one%20date)%20into%20another%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20not%20make%20it%20work%20with%20my%20If%20and%20VALUE%20functions%20can%20someone%20please%20help%20ASAP.%20TYVM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2692902%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-2692939%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20dates%20I%20add%20into%20a%20cell%20to%20have%20a%20value%20of%2025%20and%20then%20for%20them%20to%20total%20in%20another%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139540%22%20target%3D%22_blank%22%3E%40TinaMC22%3C%2FA%3E%26nbsp%3Bwhy%20not%20share%20your%20workbook.%20Just%20make%20sure%20you%20don't%20disclose%20any%20confidential%2Fprivate%20information%20of%20real%20people.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693200%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20dates%20I%20add%20into%20a%20cell%20to%20have%20a%20value%20of%2025%20and%20then%20for%20them%20to%20total%20in%20another%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693200%22%20slang%3D%22en-US%22%3EI%20am%20not%20able%20to%20upload%20docs%20or%20images%20online%20from%20my%20workstation.%3C%2FLINGO-BODY%3E
New Contributor

I have to charge everyone who is locked out 25 dollars. I have to keep track of the dates to go back and verify with camera footage. Therefor I need my cells with dates in them to each have a value of $25 and then I will add the values of the dates for each person (if there is more than one date) into another cell. 

I can not make it work with my If and VALUE functions can someone please help ASAP. TYVM

3 Replies

@TinaMC22 why not share your workbook. Just make sure you don't disclose any confidential/private information of real people. 

I am not able to upload docs or images online from my workstation.