SUMIF

  • Thread starter Remove the XX's
  • Start date
R

Remove the XX's

A1, A2, A7 all contain DLX

What I want is for all DLX in A:A to SUM the 3rd columns over. So in this
example the SUM of C1,C2,C7.

I've been playing with SUMIF but you need to select the exact range if there
is a match.

TIA, Dennis
====================
 
D

Donald Guillett

A1, A2, A7 all contain DLX

What I want is for all DLX in A:A to SUM the 3rd columns over. So in this
example the SUM of C1,C2,C7.

I've been playing with SUMIF but you need to select the exact range if there
is a match.

TIA, Dennis
====================

I am not understanding. Perhaps a better explanation or
"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
R

Rick Rothstein

A1, A2, A7 all contain DLX
What I want is for all DLX in A:A to SUM the 3rd columns
over. So in this example the SUM of C1,C2,C7.

I've been playing with SUMIF but you need to select the
exact range if there is a match.

Are you saying that this formula does not do what you want?

=SUMIF(A:A,"DLX",C:C)

Rick Rothstein (MVP - Excel)
 
R

Remove the XX's

Are you saying that this formula does not do what you want?

=SUMIF(A:A,"DLX",C:C)

Rick Rothstein (MVP - Excel)

Yes, exactly!! Thanx Rick!

Dennis
======================
 
R

Rick Rothstein

Are you saying that this formula does not do what you want?
Yes, exactly!! Thanx Rick!

If that formula does not do what you want, then why are you thanking me
(with an exclamation mark)?

Tell us then, exactly what does the formula I posted do?

Rick Rothstein (MVP - Excel)
 
P

Pete_UK

Perhaps you have one or more spaces before or after the DLX in column
A. Try this variation:

=SUMIF(A:A,"*DLX*",C:C)

The asterisk is a wildcard character, meaning any character.

Hope this helps.

Pete
 
R

Remove the XX's

If that formula does not do what you want, then why are you thanking me
(with an exclamation mark)?

Tell us then, exactly what does the formula I posted do?

Rick Rothstein (MVP - Excel)

Rick, it DOES do exactly what I want. I am thanking you because I wasn't
getting it on my own and your explanation of the syntax got me on track.
So....thank you again....dennis
 
R

Rick Rothstein

Rick, it DOES do exactly what I want. I am thanking you
because I wasn't getting it on my own and your explanation
of the syntax got me on track. So....thank you again.

Whoops! A little confusion over wording here. I had asked "Are you saying
that this formula does not do what you want?" and you answered "Yes,
exactly!!" which I took to mean "yes, it does not do what you want". I think
this is my fault because I asked my question in the negative which opened it
for how to properly answer it... sorry. Anyway, you are quite welcome... I'm
glad your problem has been resolved.

Rick Rothstein (MVP - Excel)
 
G

Gord Dibben

You have hit upon one of my pet peeves Rick.

Those unanswerable negative questions!!

Lawyer..........did you not commit the crime?

I personally would answer "yes" but how would that be interpreted by the jury?


Gord
 

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 criteria "<>" & "=" 4
sum if one or another criteria 5
Sumif with criteria help 3
Combining SUMIF and SUBTOTAL 4
SumIf AND 6
sumif wildcard criteria 1
subtotal with sumif nested 1
sumif formula 2

Top