# Count only unique cells in column where another cell in row is not blank

1. ## Count only unique cells in column where another cell in row is not blank

I want to count the unique cells in Column A That have a number in Column C and actually has a dollar amount greater than \$0.00.

A B C D
C20358 Carriage House; The 479220 \$84.11*
C20449 Historic Tamarack Lodge 481341 \$29.97*
C20449 Historic Tamarack Lodge 520668 \$9.54*
C20457 Old Forge Camping Resort 480541 \$176.04*
C20457 Old Forge Camping Resort 480591 \$0.00
C399. MCD. \$0.00

C20358
C20449
C20457

2. ## Re: Count only unique cells in column where another cell in row is not blank

e25 =if(and(C25<>"",D25>0),"yes","no")

and drag down.

After that a pivot table.

C number name number value criteria
C20358 CarriageHouse;The 479220 84,11 yes
C20449 HistoricTamarackLodge 481341 29,97 yes
C20449 HistoricTamarackLodge 520668 9,54 yes
C20457 OldForgeCamping Resort 480541 176,04 yes
C20457 OldForgeCamping Resort 480591 0 no
C399. MCD 0 no

criteria yes

Rijlabels Unieke telling van name
C20358 1
C20449 1
C20457 1
Eindtotaal 3

3. ## Re: Count only unique cells in column where another cell in row is not blank

``Please Login or Register  to view this content.``

4. ## Re: Count only unique cells in column where another cell in row is not blank

With your above sample data in Range A2:D7 use this array formula

=SUM(IF(FREQUENCY(IF((D2:D7>0)*ISNUMBER(C2:C7),MATCH(A2:A7,A2:A7,0)),ROW(A2:A7)-ROW(A2)),1,0))

Confirm with Ctrl+Shift+Enter

5. ## Re: Count only unique cells in column where another cell in row is not blank

Thanks Ace XL..I believe I just need one more step... some rows will have "N/A" showing up in column D that I would like to ignore and treat as if it was \$0

6. ## Re: Count only unique cells in column where another cell in row is not blank

Thanks Ace XL..I believe I just need one more step... some rows will have "N/A" showing up in column D that I would like to ignore and treat as if it was \$0

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.06053 seconds
• Memory Usage 9,005KB
• Queries Executed 15 (?)
Template Usage (34):
• (1)bbcode_code
• (1)footer
• (1)forumrules
• (1)gobutton
• (6)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (6)postbit_legacy
• (6)postbit_onlinestatus
• (6)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./includes/functions_notice.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php

Hooks Called (48):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit_complete