Count in series with multiple conditions

**IslasLorax** · 03-28-2012, 11:32 AM

I have a few formulas that I need to write but am having serious issues....

1. Count all the "ASY" (column I) in a series if that row also contains a "Y" (column B) - Sheet: Data!

2. Count all the "1" (column K) in a series if that row also contains "ASY" (column I) and "Y" (column B) {all on Sheet: Data!} then divide that by $B$2 to get the percentage of cells that have a 1 in that cell for ASY/Y rows

**icestationzbra** · 03-28-2012, 11:35 AM

you may want to explore using COUNTIF / COUNTIFS for this purpose.

if you can share a sample, it will help us to better visualise the issue.

**IslasLorax** · 03-28-2012, 11:45 AM

I didn't even realize there was a COUNTIFS!! Thank you, that took care of the first one. I

will try to attach an appropriate example (NOTE: the columns have all changed but the idea is the same)

Excel example.jpg

Then that number will be divided by B2 on another sheet

**icestationzbra** · 03-28-2012, 11:52 AM

$B$2 in your attachment (image) is a string, not a number. did you meant some other B2 (on some other sheet)?

it is better to attach a sample spreadsheet; we can avoid recreating your data on spreadsheet...

**IslasLorax** · 03-28-2012, 11:54 AM

I actually think the COUNTIFS formula was all I needed... I really appreciate your help. I will attach better examples next time.

**icestationzbra** · 03-28-2012, 11:56 AM

glad that it worked out well.

please close the thread as SOLVED.

Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved. To undo the action, just go back to Thread Tools -> Mark this thread as Unsolved.

**arlu1201** · 03-28-2012, 01:02 PM

Welcome to the forum, Islaslorax, unfortunately,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I know you have got your solution by now, but please remember this for future threads.