Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif/countif
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif/countif
I prefer SUMPRODUCT, but I bet some COUNTIF would work.
SUMPRODUCT(--(ae9:ae8000<distance)) Where Distance is numeric. -- HTH, Barb Reinhardt "reno" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif/countif
Thank you , I'll give it a try
"Barb Reinhardt" wrote: I prefer SUMPRODUCT, but I bet some COUNTIF would work. SUMPRODUCT(--(ae9:ae8000<distance)) Where Distance is numeric. -- HTH, Barb Reinhardt "reno" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIF or SumIF | Excel Discussion (Misc queries) | |||
Countif/Sumif | Excel Worksheet Functions | |||
Countif/Sumif | Excel Worksheet Functions | |||
COUNTIF or SUMIF or ?? | Excel Worksheet Functions | |||
Countif, Sumif | Excel Discussion (Misc queries) |