How to get counts specific to data based on other entries in rows.

**John M.** · 12-17-2015, 02:32 AM

I am attaching a spreadsheet. Columns C through G all have formulas. G is giving the correct result - It is showing the number of times that the Account number shows up on the sheet. C,D & E are not returning the needed results. These 3 columns should be giving me the counts of the specific pest reported for that account number.

I have starred at these formulas for several hours and played with them - cant get it to return the count of the specific pests... You will see what i am looking for - where am i going wrong - something is a miss.

Thanks all!

**cbatrody** · 12-17-2015, 02:38 AM

Hi,

You are getting '0' as output in columns C to E because there are extra spaces at the end & the lookup text doesn't match. See the image below:

**John M.** · 12-17-2015, 02:45 AM

Great find... how do i easily remove all extra spaces? My actual report is near 10,000 rows of data.

**cbatrody** · 12-17-2015, 02:55 AM

Add a helper column and use the following formula, it should work.

=TRIM(B2)

See the attached file.

**John M.** · 12-17-2015, 03:20 AM

cbatrody - your awesome!! Thank you!

**cbatrody** · 12-17-2015, 03:21 AM

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

How to get counts specific to data based on other entries in rows.

LinkBack

Thread Tools

Rate This Thread

Display

How to get counts specific to data based on other entries in rows.

Re: How to get counts specific to data based on other entries in rows.

Re: How to get counts specific to data based on other entries in rows.

Re: How to get counts specific to data based on other entries in rows.

Re: How to get counts specific to data based on other entries in rows.

Re: How to get counts specific to data based on other entries in rows.

Thread Information

Users Browsing this Thread

Similar Threads

How to get counts specific to data based on other entries in rows.

Getting unique rows, counts of said rows and other data manipulation

Count rows then insert formula based on row counts

Enumeration of rows based on given counts

Formula/function that counts amount of rows between specific number.

[SOLVED] Sorting rows of data based off a single column for a variable number of entries.

[SOLVED] counts rows in data

Bookmarks

Bookmarks

Posting Permissions