Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DCount?? not working. Pls help
My data is orgnaised as follows:
A B C D E David 2245 abcd efgh ijk Susan 2249 xyz etc etc Mickey 1234 etc 123 etc Arnold 4321 etc.... David 1441 Mickey abcd etc etc I want to count the number of non blank cells in B for each "David", "Susan" etc in A, and have the value returned in another sheet. I tried DCount, but it doesnt seem to be working. -- KDDXB |
#2
|
|||
|
|||
I mocked up your data as you provided it, with names in A1:A6 etc. I
entered "David" in A8 and this formula in B8: =SUMPRODUCT(--($A$1:$A$6=A8),--($B$1:$B$6<"")) |
#3
|
|||
|
|||
Amazing stuff. Perfect. Thank you my friend.
-- KDDXB "Dave O" wrote: I mocked up your data as you provided it, with names in A1:A6 etc. I entered "David" in A8 and this formula in B8: =SUMPRODUCT(--($A$1:$A$6=A8),--($B$1:$B$6<"")) |
#4
|
|||
|
|||
Glad to help!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
Filter not working in a protected file | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions |