Sum data ignoring text using the sumproduct with logic

1. Sum data ignoring text using the sumproduct with logic

Can someone please show me how to use the sumproduct with logic using logic such as (--(logic test))?

The attached has a simple example. I thought using the * would return an error if it detects text, and using the comma would ignore the text.

Thank you.

2. Re: Sum data ignoring text using the sumproduct with logic

I think, in this case, you have to use the asterisk (*) to multiply the matrices because they are different sizes.

On the other hand, if the matrices are the same size, you can choose either approach.

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

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

C14:C23=103 produces an array of TRUE or FALSE values. The double negative coerces these TRUE or FALSE values into 1 or 0 respectively. The matrix of 1 and 0 values is then multiplied by the matrix of values in F14:F23 and the results summed.

Regards, TMS

3. Re: Sum data ignoring text using the sumproduct with logic

This will ignore text:
Formula:
`Please Login or Register  to view this content.`

It's an array formula, it has to be entered with Ctrl + Shift + Enter.

Well explained Trevor!

4. Re: Sum data ignoring text using the sumproduct with logic

@Jacc: thanks, and you're welcome.

Regards, TMS

5. Re: Sum data ignoring text using the sumproduct with logic

Thanks to all of you!

6. Re: Sum data ignoring text using the sumproduct with logic

You're welcome.

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

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