Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Countifs w/an OR
Name: Stumped Date: January 30, 2009 at 09:03:52 Pacific OS: Windows XP Subcategory: General
Comment:
I am trying to count the number of times where a criteria is satisfied in Column A OR Column B. That is, count the number of times that Age in Column A is <10 or Age in Column B is <10. If I use the Countifs it returns the number of times both criteria are met and I am at a loss for how to say Countif this OR this criteria is met, not countifs this AND this criteria is met. Help!
Name: Ed in Texas. Date: January 30, 2009 at 23:28:17 Pacific
Reply:
Stumped, seems to me that you just need a couple of variables. Use the countifs statement in conjunction with an if/then/else statement to determine col. A or col. B so you know which one to increment. Increment variable 'A' or 'B' as each is encountered and then print the variables when you're done and reset so you're ready for next time. HTH. Ed in Texas.
Summary: My computer has drive c: 16GB FAT32 and drive d: 44 GB NTFS. I am going to be doing a system recovery (XP home edition came pre-loaded...on recovery disk) for misc reasons. Not sure if system reco...
Summary: hi! i've heard around that you cn do a clean install of windows xp using only an upgrade CD. is this true? if so, how do i do it? just out of curiousity, how does it work? i always thought that an u...
Summary: I'm not sure if this is the right place to post--please let me know if this should be under CPU or something else. I've been experiencing a growing # of apparently disconnected computer problems and h...
0 
Mass Mailing doesn't work...
