Array argument issues for Sumif

Issue I’m trying to make the following formula work and it’s giving me "Array arguments to SUMIFS are of different size." =SUMIFS(ChronologicalExpenditures!I2:I995, ChronologicalExpenditures!N3:N, "*"&H2&"*", ChronologicalExpenditures!B3:B, "Expenditure, Contractor") Basically, I want to add the values in "ChronologicalExpenditures!I2:I995" together, ONLY if "ChronologicalExpenditures!N3:N"

Continue reading

How to find sum of multiple inputs (inputs can increase by add button) from different containers?

Issue function appendDiv() { var e = “<div>\ <button onclick=’appendBox(this)’>ADD NUMBER BOX</button>\ <input type=’number’ class=’sumOfTotal’ readonly>\ </div>” $(“body”).append(e); } function appendBox(This) { var e = “<div><input type=’number’ class=’number’></input>\ <button onclick=’removeNum(this)’>DELETE NUM</button></div>” $(This.closest(‘div’)).append(e); } function removeNum(This) { $(This.closest(‘div’)).remove(); } <!DOCTYPE html>

Continue reading