Recent content by JerrySpringer

hi =Sum(iif([City]="NewYork",1,0)) This should work. Good Luck Mosmas

Hi, Is it possible to do a vlookup with 2 lookup values? I have a list like such; abc 1 orange abc 2 Apple abc 3 Grape cde 1 Pear cde 2 Banana I need to look up the first value "ABC" then the second "2" and pull back apple. is this possible? Thank...

Hi Wray, I love this area code spreadsheet alot. Its going to assist me in calling my clients so much. JS

Hey guys, Thanks for your responses,Im still not getting it to work correctly though. My previously derivied calculated fields are not there to pick from, and I tried using Geoff's formula and it returns all 1's. It is probally something I am doing incorrectly though, I will play with it a bit...

OK, I had such good luck on my first post I decided to try another. I was working on this a few weeks ago and gave up. I have two data fields in a pivot table that are set to count. How would I divide one by the other in the pivot table? Am I making sense and is this possible? THank You, JS

WOW, that was quick.... And it works perfectly, I have been trying to accomplish this for 2 weeks, wish I would of found this forum sooner. Thank you so much Wray. JS

I keep my invetory in EXCEL. In cell E21 I have current stock, in F21 I have monthly usage, and in G21 I have the following formula =ROUND(E21/F21,0)-1 which tells me how many months of product I have. What I would like in H21 is a formula that tells me the month that I will re-order. Anyone...