0:00
sum if with wild card in Excel. It's
0:02
fast and easy. Instead of doing it
0:03
manually, try this method. It's faster
0:05
and more efficient. This won't give us a
0:07
dynamic total, which is why we'll use a
0:09
better method here. Let's use this
0:10
approach. We have filtered a few product
0:12
names from the data. For example, here
0:14
we have apple and banana. We'll use sum
0:16
if, but not the usual way you've seen
0:18
before. In sum if, we choose the range
0:20
and then define the criteria that
0:21
filters what gets added. We'll enter the
0:23
fruit name as our criteria, and it'll
0:24
total up all the relevant prices for us.
0:26
This approach won't return the correct
0:28
output because it doesn't process the
0:29
condition the way we need. Normally, it
0:31
looks for an exact match. But by using a
0:33
wild card, we can expand the search to
0:34
partial matches to get Apple's total.
0:36
Here's what we'll do next. Put the
0:38
symbol inside inverted commas. Then
0:39
connect it using amperands just like
0:41
this. By adding this symbol star, Excel
0:43
will search the entire range and pick
0:45
out anything that includes Apple. If
0:46
Apple appears at the beginning or end of
0:48
a product name, this formula will still
0:49
pick it up. This will total the value.
0:51
But if we adjust this input, the output
0:53
will change accordingly. Based on the
0:54
criteria, it will automatically sum the
0:56
matching value. For more tips, tools,
0:59
www.xelautomation.in.
