can anyone simplify this equation please?

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)
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
I can't understand that, it's there when I look and I've just clicked on the link and downloaded the workbook (book1), then opened it and the functions are there on K5 & Q5??

Maybe your browser needs refreshing??? :) Thanks!
 
Upvote 0
Thanks for all your help guys, I'm going to start a new thread, as this is almost a new topic to see if I can get further help with my last 3 remaining issues. Much appreciated once again! :)
 
Upvote 0

Forum statistics

Threads
1,214,911
Messages
6,122,196
Members
449,072
Latest member
DW Draft

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top