Jefferson Davis 8.Feb.12 02:32 PM a Web browser 1-2-3All ReleasesWindows XP
Hello all,
I'm attempting to count specific cells in 1 column based on data in a different column. I think that I need to use a database formula, but, don't have enough experience in combining @functions to get the job done.
I've named the table: D-P1_DATA_TABLE and it's range is: I19 ...X88.
The column range I'm attempting to look at is; J19...J88 and titled: "U-NUM".
The column range I'm attempting to count from is: K19...K88 and is titled: "UP".
I'm attempting to find 5's in the "U-NUM" range and count all cells in the "UP" range that contain a "U" that are on the same row.
Example:
5 U
5
5 U
5 U
5
I've attempted to use CountIf and DCount but they won't allow for multiple criteria for the arguments. SumIf looks right but it "sums" the data instead of counting the cells. Is there a way to reference 1 column cells and count a different column cells?
Thanks ahead of time for any guidance. JD
Edited several hours later:
Thank you for reading this. I discovered that my problem was with how I assigned a range name, and the use of "" (quotation marks). Below is the working formula if anyone stumbles across this post and is looking for the answer:
@DCOUNT($D_P1_DATA_TABLE,0,J20=5#AND#K20="U")
Notice in my original post, the range name: D-P1_DATA_TABLE has a hyphen in the name. The correct way (I discovered) is: D_P1_DATA_TABLE. No "-" (hyphen), an "_" (under score)...
Return to top
Counting cells in a database (Jefferson Davis... 8.Feb.12)
. . 
Print this page
