Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF
I want to use SUMIF the first four letters of the row are "Pear" without
concern as to what the ending is. I can't seem to get the Left(range,4) to work with SUMIF. Any ideas? Apple 6 Pear 5 Pears 4 Pearx 3 Pear 2 Thanks. Joe |
#2
|
|||
|
|||
Do a google search on your name and you'll find that Jason Morin answered
your question, here's his answer =SUMIF(1:1,"Pear*",2:2) -- Regards, Peo Sjoblom "Joseph" wrote in message ... I want to use SUMIF the first four letters of the row are "Pear" without concern as to what the ending is. I can't seem to get the Left(range,4) to work with SUMIF. Any ideas? Apple 6 Pear 5 Pears 4 Pearx 3 Pear 2 Thanks. Joe |
#3
|
|||
|
|||
Try the following...
=SUMIF(A1:A5,"Pear*",B1:B5) OR =SUMIF(A1:A5,C1&"*",B1:B5) ....where C1 contains your criterion. Hope this helps! In article , "Joseph" wrote: I want to use SUMIF the first four letters of the row are "Pear" without concern as to what the ending is. I can't seem to get the Left(range,4) to work with SUMIF. Any ideas? Apple 6 Pear 5 Pears 4 Pearx 3 Pear 2 Thanks. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF - HLOOKUP Combination | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |