SOLVED

Determine total value based on condition in cell in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2724898%22%20slang%3D%22en-US%22%3EDetermine%20total%20value%20based%20on%20condition%20in%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724898%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI'm%20trying%20to%20make%20a%20small%20application%20in%20Excel.%20For%20example%2C%2012%20payment%20records%20are%20kept%20in%20a%20table.%20I%20want%20it%20to%20be%20deducted%20from%20the%20total%20amount%20of%20money%20when%20%22paid%22%20is%20written%20in%20the%20cell%20next%20to%20the%20received%20payment%20in%20these%20records.%20I%20made%20a%20study%2C%20but%20as%20you%20will%20see%20in%20the%20appendix%2C%20I%20cannot%20maintain%20it%20in%20the%20same%20cell.%20How%20can%20I%20check%20this%3F%3C%2FP%3E%3CP%3Eformule%20is%3A%20%3DIF(%24E3%3D%22Paid%22%2CD14-D3%2CD14)%20but%20I%20actually%20want%20to%20check%20it%20in%20the%20cell%20where%20the%20total%20money%20is%20not%20a%20single%20row%2C%20it%20should%20change%20automatically%20according%20to%20the%20value%20of%2012%20cells.%20scrolling%20down%20like%20this%20is%20not%20a%20solution%20for%20me.%20What%20can%20I%20do%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel1.PNG%22%20style%3D%22width%3A%20472px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308333iD1912CA1EB7B0A42%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel1.PNG%22%20alt%3D%22excel1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2724898%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2725008%22%20slang%3D%22en-US%22%3ERe%3A%20Determine%20total%20value%20based%20on%20condition%20in%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2725008%22%20slang%3D%22en-US%22%3E%3CP%3E%3DSUMIF(E3%3AE14%2C%20%22Paid%22%2C%20D3%3AD14)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,
I'm trying to make a small application in Excel. For example, 12 payment records are kept in a table. I want it to be deducted from the total amount of money when "paid" is written in the cell next to the received payment in these records. I made a study, but as you will see in the appendix, I cannot maintain it in the same cell. How can I check this?

formule is: =IF($E3="Paid",D14-D3,D14) but I actually want to check it in the cell where the total money is not a single row, it should change automatically according to the value of 12 cells. scrolling down like this is not a solution for me. What can I do?excel1.PNG

1 Reply
best response confirmed by MelsZey (Occasional Visitor)
Solution

=SUMIF(E3:E14, "Paid", D3:D14)