Summing Cells that are a Multiple of 15

[birdasaurus]

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.

 

[Special-K99]

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")

 

[CodeNinja]

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)

 

[birdasaurus]

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

 

[West Man]

Try: =SUMPRODUCT(--(MOD(A1:A19,15)=0),A1:A19)
Adjust ranges to suit