Sum value in cells that contain both number and text

I need to sum a range of cells with text in them.


a1= "25,00 market"  b1="24,00 credit card" c1="75,11 food" a2= "10,00 sweets"  b2="9,00 market"       c2="24,00 keyboard" 

I want to sum all the numbers in cells that contain “market” in this range. Something like:

 =SUMIF(a1:c2; "*market*"; a1:c2 )  

But this always returns the value 0.

What am I doing wrong?

Can a persistent spell cast using the Sorcerer’s Metamagic Twinned Spell affect both spells?

The description for the Sorcerer Metamagic Twinned Spell says:

When you cast a spell that targets only one creature and doesn’t have a range of self, you can spend a number of sorcery points equal to the spell’s level to target a second creature in range with the same spell (1 sorcery point if the spell is a cantrip).

To be eligible, a spell must be incapable of targeting more than one creature at the spell’s current level. For example, magic missile and scorching ray aren’t eligible, but ray of frost and chromatic orb are.

The general upswing is the Sorcerer can cast two Mage Armor or two Suggestion spells. Something with instantaneous results. But what happens when the spell has follow up abilities?

The situation came up when a Cleric/Divine Soul Sorcerer cast a Twinned Spiritual Weapon (in the form of a hammer).

As a bonus action on your turn, you can move the weapon up to 20 feet and repeat the attack against a creature within 5 feet of it.

Can the Sorcerer move and attack them independently? Or use one Bonus Action to move attack one round and wait until the next round to move/attack the other?

I found a similar spell, and this one directly effects a creature: Dominate Beast.

You can use your action to take total and precise control of the target. Until the end of your next turn, the creature takes only the actions you choose, and doesn’t do anything that you don’t allow it to do. During this time, you can also cause the creature to use a reaction, but this requires you to use your own reaction as well.

Can the Sorc control both beasts in the same round?

create 500,000 both onpage and offpage SEO backlinks for shopify promotion for $5

“Create 500,000 both onpage and offpage SEO backlinks for shopify promotion” Instant access to the best ranking low competition PPC keywords for your ad campaign use and back end search terms so your product can RANK BETTER IN SEARCH RESULTS This deal may be over soon. If the limited seats are filled, you must wait till God knows when! Service We Provide: Dedicated Personals For Aamazo SEO. Highly Qualified TeamProfessionals in Every AspectImmensely Focused Completions of Task Make sure that you have checked Gig extras for better opportunities Check Gig Extras for Better Opportunities ! We can run a effective link building campaign a good way to build excessive first-rate backlinks in a completely short time.we will use plenty of engines and max variety of appropriate systems with particular domain names. We can also use top rate Indexing offerings to get faster & effective results. we will ship you a complete and specific detailed Report. Create 500,000 both onpage and offpage SEO backlinks for shopify promotion Order Now and Avail this Opportunity

by: indexwebseo
Created: —
Category: Link Development
Viewed: 215

Deleting messenger conversation on both sides

I need to remove a conversation history on both sides. Asking politely is not an option i’m afraid. This statement seems logical. Has anyone tried it and does it work? “start by accessing your conversation in Facebook Messenger. Make sure to open the specific thread with the individual you wish to remove. Click the wheel in the top right corner to open the Options for the conversation. Choose “Delete Conversation” to remove all of the messages. Select the “Options menu” again and choose “Block User” to prevent any further interactions on Messenger with this individual. Next, open that person’s profile in Facebook and choose “Unfriend” to permanently remove the connection and all conversations.”

How to handle check-able tree-view nodes that act as both a group and an item

I need to create a tree-view which allows users to select nodes (using a checkbox). The tree-view contains two types of node, “group” and “item”. A “group” node can contain both “group” and “item” nodes. An item node can’t contain other nodes. Crucially selecting a group node should automatically select all node below it (to the bottom of the tree).

However, due to this last criteria I can’t figure out the following behaviour (I make reference to the attached diagram).

  1. The user selects Group A
  2. Now Group A, Group B, Item 1 and Item 2 are now checked.
  3. The user then deselects Item 1

What should the state of Group A be (checked, unchecked or indeterminate)?


How can I filter a view by Content Type -or- Taxonomy Term and have both sets of items show?

I have a basic view that works great. It shows a list of nodes that are filtered by content type.

To that list of allowed content types, I want to add a taxonomy term. That is, the view should show anything that is a certain special content type, but ALSO include any node that has a certain special taxonomy term, no matter what the content type is.

The view that already works fine has its filter setup this way:


Content: Content type (is one of: Blog, IM, PI)

Easy, no problem. To add the taxonomy term, I set it up this way:


     Content:  Content type (is one of: Blog, IM, PI)  OR     Content: Has taxonomy term (= News Release) | Settings 

Here’s where it went all wrong on me. As soon as I added the taxonomy term filter, the items that should be there by Content Type completely disappeared. Only items with the taxonomy term show up in the view now. If I remove the taxonomy term filter, then items in the Content type pop back in again. It’s like the taxonomy filter suppresses the content type filter in some way.

I tried:

  • using Content: Resource Type (= News Release) | Settings which was an alternate way of listing the taxonomy, “Resource Type” being the vocabulary
  • using AND instead of OR but, as you would expect, that returned no results at all because I do not have any of the special three content types that are also labeled as the special taxonomy “News Item”. They are separate use cases.
  • using filter groups, listing the content type, an OR, and a content type AND taxonomy:

    Content:  Content type (is one of: Blog, IM, PI) OR Content: Content type (= Article) AND Content: Has taxonomy term (= News Release) | Settings 

To be clear, either the node is a special content type OR the node is a regular content type with a special taxonomy term. Never both. Both types of nodes should appear side-by-side in this view.

Am I not allowed to make a view that shows stuff filtered by taxonomy alongside stuff filtered by content type at the same time? Can anyone suggest something for me to try?

Postfix relay authentication for both server and client

I built a postfix relay several years ago that relays through office365. This is limited to hosts on the VPN, but now want to provide a public IP and allow remote printers to relay through postfix for send to email.

My issue is a lack of understanding of how to add smtp authentication for the printers to use without messing up the authentication for office365. I think this is purely a perspective issue.

The new postifix installation is running in Docker using the config found here and works just like my old install.

When I combine two video using ffmpeg with C# then Duration is greater then addition of both video’s duration?

I have two file one has video length is 00:02:18 and second videos duration is 00:01:25 then I combined both video using ffmpeg command in c# then after combine video’s length should be 00:03:43 but when I see the output video’s length is 00:04:03. I can not figure out why this happen.

ConvertCommand = String.Format($  @"-y -safe 0 -f concat -i ""{CombineTextList}"" -fflags +genpts ""{CombinedVideo}""", CombineTextList, CombinedVideo); 

I am using this ffmpeg command for combining video.

  1. CombineTextList is path of the text file which has the path of inputfile.
  2. CombinedVideo is the path of output file.
  3. ConvertCommand is for FFMPEG command.

    CombineTextList :

file ‘C:\Users….mp4 file ‘C:\Users….mp4

Note: I am using ffmpeg in c# windows form application.