# Count cells that are a perfect multiple of adjacent cell?

1. ## Count cells that are a perfect multiple of adjacent cell?

Any ideas on how i would count cells where one cell is a perfect multiple of the adjacent cell?

Basically counting a cell with a whole number.

2. ## Re: Count cells that are a perfect multiple of adjacent cell?

Something like:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Count cells that are a perfect multiple of adjacent cell?

That doesn't seem to work for me. Probably because i dont understand it. Do you know how i can attach the example to make this easier?

4. ## Re: Count cells that are a perfect multiple of adjacent cell?

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

5. ## Re: Count cells that are a perfect multiple of adjacent cell?

Hope there is an attachment with this.

6. ## Re: Count cells that are a perfect multiple of adjacent cell?

I attached the sample. Thanks for your help.

7. ## Re: Count cells that are a perfect multiple of adjacent cell?

D2:
Formula:
`Please Login or Register  to view this content.`
copied down

Total:
Formula:
`Please Login or Register  to view this content.`

8. ## Re: Count cells that are a perfect multiple of adjacent cell?

Try
Formula:
`Please Login or Register  to view this content.`

9. ## Re: Count cells that are a perfect multiple of adjacent cell?

Thanks so much for your help.

11. ## Re: Count cells that are a perfect multiple of adjacent cell?

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1