englishdad
Board Regular
- Joined
- Mar 4, 2016
- Messages
- 58
I'm thinking it could be done using a sumifs function but I can't get past the thinking stage! Any help, as always, is very much appreciated. Thanks in advance
SUMIF(C7:C41,"PAID",D7:D41)+SUMIF(F7:F41,"PAID",G7:G42)+SUMIF(I7:I41,"PAID",J7:J41)+SUMIF(L7:L41,"PAID",M7:M41)+SUMIF(O7:O41,"PAID",P7:P42)+SUMIF(R7:R41,"PAID",S7:S41)+SUMIF(U7:U41,"PAID",V7:V42)+SUMIF(X7:X41,"PAID",Y7:Y41)+SUMIF(AA7:AA41,"PAID",AB7:AB41)+SUMIF(AD7:AD41,"PAID",AE7:AE41)+SUMIF(AG7:AG41,"PAID",AH7:AH41)+SUMIF(AJ7:AJ41,"PAID",AK7:AK41)+SUMIF(AM7:AM41,"PAID",AN7:AN41)+SUMIF(AP7:AP41,"PAID",AQ7:AQ41)+SUMIF(AS7:AS41,"PAID",AT7:AT41)+SUMIF(AV7:AV41,"PAID",AW7:AW41)
SUMIF(C7:C41,"PAID",D7:D41)+SUMIF(F7:F41,"PAID",G7:G42)+SUMIF(I7:I41,"PAID",J7:J41)+SUMIF(L7:L41,"PAID",M7:M41)+SUMIF(O7:O41,"PAID",P7:P42)+SUMIF(R7:R41,"PAID",S7:S41)+SUMIF(U7:U41,"PAID",V7:V42)+SUMIF(X7:X41,"PAID",Y7:Y41)+SUMIF(AA7:AA41,"PAID",AB7:AB41)+SUMIF(AD7:AD41,"PAID",AE7:AE41)+SUMIF(AG7:AG41,"PAID",AH7:AH41)+SUMIF(AJ7:AJ41,"PAID",AK7:AK41)+SUMIF(AM7:AM41,"PAID",AN7:AN41)+SUMIF(AP7:AP41,"PAID",AQ7:AQ41)+SUMIF(AS7:AS41,"PAID",AT7:AT41)+SUMIF(AV7:AV41,"PAID",AW7:AW41)