Sumif/countif

R

reno

have a range of of 8000 rows organized by zip codes
have formula to calculate distance from inputed specific zipcode--- named
"distance"
have 12 columns that use vlookup to see if specific stores are within that
zipcode, if yes places an "X" else blank. (could change to "1")

while it seems simple enough to countif [if value is X countif <=distance]
but am getting incorrect results...the formula
countif(ae9:ae8000,"<distance",ag9:ag8000) where distance is entered
 
B

Barb Reinhardt

I prefer SUMPRODUCT, but I bet some COUNTIF would work.

SUMPRODUCT(--(ae9:ae8000<distance))

Where Distance is numeric.
 
R

reno

Thank you , I'll give it a try

Barb Reinhardt said:
I prefer SUMPRODUCT, but I bet some COUNTIF would work.

SUMPRODUCT(--(ae9:ae8000<distance))

Where Distance is numeric.
--
HTH,
Barb Reinhardt



reno said:
have a range of of 8000 rows organized by zip codes
have formula to calculate distance from inputed specific zipcode--- named
"distance"
have 12 columns that use vlookup to see if specific stores are within that
zipcode, if yes places an "X" else blank. (could change to "1")

while it seems simple enough to countif [if value is X countif <=distance]
but am getting incorrect results...the formula
countif(ae9:ae8000,"<distance",ag9:ag8000) where distance is entered
 

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


Top