Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you both! That worked!
"Bob Phillips" wrote: B2: =SUMPRODUCT(--(Sheet2!$A$2:$A$200=B$1),--(Sheet2!$B$2:$B$200=A$2)) copy down and across -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "reddy" wrote in message ... I have 2 worksheets. I want to obtain the summary counts in worksheet 1 from Worksheet 2. What formula should I use to poulate worksheet 1. Worksheet 1 2008 File counts by Lender and Month Lender Jan Feb Mar Aurora 3 2 4 BofA 6 7 8 CCM 8 9 5 Worksheet 2 Jan Aurora 1 Jan Aurora 1 Jan Aurora 1 Feb Aurora 1 Feb Aurora 1 Mar Aurora 1 Mar Aurora 1 Mar Aurora 1 Mar Aurora 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
How to count number of occurences of two different things at once? | Excel Worksheet Functions | |||
count number of occurences on a particular date | Excel Worksheet Functions | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
count number of occurences within a string | Excel Worksheet Functions |