Sumif

  • Thread starter Thread starter alexm999
  • Start date Start date
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
 
Hi
try
=SUMPRODUCT((A1:A100=101)*(E1:E100="TV"),D1:D100)

or
=SUMPRODUCT(--(A1:A100=101),--(E1:E100="TV"),D1:D100)
 
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
 
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
 
Back
Top