SUMIF criteria

B

B Rabbit

I have a spreadsheet and I am running a SUMIF to a second and I am having
trouble with the search criteria. The original reference is a 3 or 4 digit
number and the criteria I am searching for has a text discriptor in front of
that 3 or 4 digit number. Is there a way to have the SumIf formula figure out
that I am just looking for the number and not the text and number. The
criteria search does have a "-" between the word and the number.

i.e. I am searching for "134"and the column is set up "abc-1234" and I want
to use the 1234.

My formula is : =SUMIF('Labor March'!A6:A896,A9,'Labor March'!L6:L896)
 
B

Bob Umlas, Excel MVP

Try using SUMPRODUCT - something like
=SUMPRODUCT(N(MID('Labor March'!A6:A896,FIND("-",'Labor
March'!A6:A896)+1,10)=A9&""),'Labor March'!L6:L896)

Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with the criteria range 4
Use TODAY() function as the criteria in a SUMIF formula 1
sumif wildcard for text and numbers 5
Page numbering with Merged Document and IF statements 1
remembering the same filtering criteria 13
SUMIF with criteria "<>" & "=" 4
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Sumif does not work 2

Top