Count cells in column unless they've already been counted

1. Count cells in column unless they've already been counted

I need a formula that will count cells in a column that were not already counted for another result. In the attached, I have formulas to count (columns M & N) each decision type (columns D & E) based on type (text). For column T, I have a UDF (cells T7, 9 & 11) to count cells based on color fill of column E, but now I need a formula to count the remaining cells in colum E for results in cells T16 & 18, and U24. The formula will need to count cells (column E) based on text but w/o color fill. Hope this makes sense.

Can anyone help??

Thanks,
JB

2. Re: Count cells in column unless they've already been counted

In reviewing some other threads, I'm wondering if COUNTIFS would work for my situation. If so, how would the formula look?

thanks,
JB

3. Re: Count cells in column unless they've already been counted

Could you not just use the same UDF, based on color white?

4. Re: Count cells in column unless they've already been counted

Unfortunately not becuase the remaining two categories I'm trying to get results for have different types and using white would just include them all rather than give me an accurate count. Unless I'm not understanding your suggestion correctly. Do you have an example formula I can test?

JB

5. Re: Count cells in column unless they've already been counted

OK didnt catch that there was more than 1 total required

What are the criteria for teh 2 totals? maybe provide a sample answer?
(countif will do just that - count, not sum)

6. Re: Count cells in column unless they've already been counted

Hi Ford,

the criteria are:

A - count all "S O; No CA/N","S O; Unbrn Vctm","S O; Ref to LE","S O; Anon clr","S O; Previous rprt","S O; same alleg", but do not count any of the blue, red or green (fill) cells

B - count all "FRS - Non CPS”,“FVS - Non CPS", but do not count any of the blue, red or green (fill) cells

I've played with a couple formulas and the closest I've gotten to getting the results I wanted is this, but it still didn't pick up all of the cells:

=COUNTIFS(\$E\$6:\$E\$54,{"S O; No CA/N","S O; Unbrn Vctm","S O; Ref to LE","S O; Anon clr","S O; Previous rprt","S O; same alleg"},\$E\$6:\$E\$54,"<>ColorFunction(\$W\$7)",\$E\$6:\$E\$54,"<>ColorFunction(\$W\$9)",\$E\$6:\$E\$54,"<>ColorFunction(\$W\$11)",\$E\$6:\$E\$54,"<>ColorFunction(\$W\$27)")

thanks for helping,
JB

7. Re: Count cells in column unless they've already been counted

Sorry, guess I should have clarified:

Cell T16 = count all "S O; No CA/N","S O; Unbrn Vctm","S O; Ref to LE","S O; Anon clr","S O; Previous rprt","S O; same alleg", but do not count any of the blue, red, green or yellow (fill) cells

Cell T18 = count all "FRS - Non CPS”,“FVS - Non CPS", but do not count any of the blue, red, green or yellow (fill) cells

Also, cell W27 has the light yellow fill.

Users Browsing this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1