Sumif

A

alexm999

I have 5 columns of data and need a little SUMIF help... this is what
have:
=SUMIF(e:e,"yellow pages",D:D)
the above statement works fine, but it totals everything that is yello
pages.
I need something that will add up just specific column A:A data compar
it to the above sumif statement and output a number...
for example:
A B C D E
101 John Smith 1/1/2004 500 Yellow Pages
102 Amy Smith 1/2/2004 650 TV
101 Bill Smith 1/3/2004 540 Yellow Pages

I want to add up just the yellow pages for 101 in column A, then add u
the TV in column
 
F

Frank Kabel

Hi
try
=SUMPRODUCT((A1:A100=101)*(E1:E100="TV"),D1:D100)

or
=SUMPRODUCT(--(A1:A100=101),--(E1:E100="TV"),D1:D100)
 
A

alexm999

Works fine... Thank you...
One more question:

How do i incorporate the COUNTIF statement?
I have this:
=countif(e:e,"yellow pages")

i'd like to do it so it counts 101 data with yellow page
 
A

alexm999

here's a more info:

I'd like to count the amount of yellow pages are for 101 (column a
 
F

Frank Kabel

Hi
what is the exact formula you have used. Note: Both ranges have to have
the same size. e.g.
=SUMPRODUCT(--(A1:A102=101),--(E1:E100="yellow pages"))

would trhow a #NUM error
 

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

Sum up 2 or more columns under same SUMIF criteria 2
Sumif w/ relative column reference 4
Problem with SUMIF 3
Macro to clean up data 8
Adding Multiple Pages(Tabs) 2
Sumif based on column A and title of another column 7
Array Formula With Multiple Conditions 3
Sumif with multiple columns in sum_range 17

Top