# Summing Cells that are a Multiple of 15

#### birdasaurus

##### New Member
I am working on a sum formula for a column and I only want to sum if the value is a multiple of 15 or likewise if the value divided by 15 is an integer. I know that I could use several sumif statements to accomplish this, but there isn't really a maximum value. Is there a simpler way to accomplish this? I am comfortable enough with VBA so that is definitely an option as well.

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
You havent said what to do if ithe sum is not 15 so...

=IF(MOD(SUM(A1:A10),15)=SUM(A1:A1),"It's not a multiple of 15")

use a helper column (formula example is in column B).... =mod(A1,15) and copy down... then do a sumif... =SUMIF(B1:B5,0,A1:A5)

Thank you! That works great. I wasn't even aware that there was a mod function in Excel, but that suits this perfectly!

Try: =SUMPRODUCT(--(MOD(A1:A19,15)=0),A1:A19)

Replies
6
Views
572
Replies
0
Views
204
Replies
3
Views
385
Replies
7
Views
407
Replies
4
Views
692

1,196,057
Messages
6,013,178
Members
441,752
Latest member
klfezler

### 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.

### Which adblocker are you using?

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

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