Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok, here is what I need to do: I need to count the number of
"Consulting" column, the number of times it was initiated by "Proposal", and the month that it occurred in, which is the numerical (serial) value of the month. The month I am currently working on is September. So if there were two proposals for consulting services during the month, I need that to be reported back to a cell. I started with the below array but just could not get it to work. It is a variation of another array I used to check revenue using the same parameters but without trying to separate the RFP and Consulting from the list. I am pretty sure I am screwing up on the COUNTIF because I get "0" in my answer cell. =SUM(COUNTIF($G$4:$G$5000,"Consulting")*($T$4:$T$5 000=38930)*($S$4:$S$5000<=38960)*((COUNTIF(D4:D40 0,"Proposal")))) RFP WEB 38935 PROPOSAL CONSULTING 38936 RFP MARKETING 38937 RFP CONSULTING 38938 PROPOSAL MARKETING 38939 PROPOSAL WEB 38940 Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display an array of references | Excel Worksheet Functions | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |