Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
another question
Thanks guys - those were all so helpful. I have another question now. How
can I pull multiple information from one column with the same count if. For instance, what if I want all of the 5/11/09 (column B) that contain these words in Column D "*assoc*" or "*a.a.s.* or "*management*". Thanks again!!! "EJV" wrote: I have a column with dates and then a column with 1s and 0s. I want to count how many of the rows that have "5/11/09" in column B also have a "1" in column BC. I have been reading the suggestions in here and this is the formula that I have been trying to use. (Note: Sheet 2 contains all of my data. I am trying to pull it into a report on Sheet 1.) It keeps coming back with zero, but I know that there are some. I have checked my data to make sure that it doesn't contain any spaces. =SUMPRODUCT((Sheet2!B2:B1242="05/11/2009")*(Sheet2!BC2:BC1242="1")) Thanks a million!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Question | Charts and Charting in Excel |