Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif programming function
Would someone please show me how to write an equation to count the number of
entries that meet more than 1 condition. I need to count the number of any COLOR of "green" with an "Approved" STATUS (answer: 3)? Thanks a bunch, A B 1 COLOR STATUS 2 Yellowgreen Pending 3 Green Approved 4 Green Pending 5 Bluegreen Approved 6 Red Approved 7 Yellow Approved 8 Green Approved 9 Bluegreen Pending |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif programming function
Put in a helper column with concantenate which will look like this
GreenApproved with code like this =B3&C3 then have your criteria in two seperate columns =COUNTIF(D3:D9,D2&E2) green in D2 and Approved in E2 I come back with 2 so are you wanting to get all approved that contain green anywhere in the name? -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "RegRat" wrote: Would someone please show me how to write an equation to count the number of entries that meet more than 1 condition. I need to count the number of any COLOR of "green" with an "Approved" STATUS (answer: 3)? Thanks a bunch, A B 1 COLOR STATUS 2 Yellowgreen Pending 3 Green Approved 4 Green Pending 5 Bluegreen Approved 6 Red Approved 7 Yellow Approved 8 Green Approved 9 Bluegreen Pending |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif programming function
If you have more than one criteria, use the SUMPRODUCT function. Try this:
=SUMPRODUCT(--(NOT(ISERROR(SEARCH("green",A1:A8)))),--(B1:B8="approved")) HTH, Elkar "RegRat" wrote: Would someone please show me how to write an equation to count the number of entries that meet more than 1 condition. I need to count the number of any COLOR of "green" with an "Approved" STATUS (answer: 3)? Thanks a bunch, A B 1 COLOR STATUS 2 Yellowgreen Pending 3 Green Approved 4 Green Pending 5 Bluegreen Approved 6 Red Approved 7 Yellow Approved 8 Green Approved 9 Bluegreen Pending |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif programming function
Yes, I need a total count of all approved with green anywhere in the name.
thanks, "John Bundy" wrote: Put in a helper column with concantenate which will look like this GreenApproved with code like this =B3&C3 then have your criteria in two seperate columns =COUNTIF(D3:D9,D2&E2) green in D2 and Approved in E2 I come back with 2 so are you wanting to get all approved that contain green anywhere in the name? -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "RegRat" wrote: Would someone please show me how to write an equation to count the number of entries that meet more than 1 condition. I need to count the number of any COLOR of "green" with an "Approved" STATUS (answer: 3)? Thanks a bunch, A B 1 COLOR STATUS 2 Yellowgreen Pending 3 Green Approved 4 Green Pending 5 Bluegreen Approved 6 Red Approved 7 Yellow Approved 8 Green Approved 9 Bluegreen Pending |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif programming function
I think you could eliminate the NOT function call:
=SUMPRODUCT(--ISNUMBER(SEARCH("green",A1:A8)),--(B1:B8="approved")) "Elkar" wrote: If you have more than one criteria, use the SUMPRODUCT function. Try this: =SUMPRODUCT(--(NOT(ISERROR(SEARCH("green",A1:A8)))),--(B1:B8="approved")) HTH, Elkar "RegRat" wrote: Would someone please show me how to write an equation to count the number of entries that meet more than 1 condition. I need to count the number of any COLOR of "green" with an "Approved" STATUS (answer: 3)? Thanks a bunch, A B 1 COLOR STATUS 2 Yellowgreen Pending 3 Green Approved 4 Green Pending 5 Bluegreen Approved 6 Red Approved 7 Yellow Approved 8 Green Approved 9 Bluegreen Pending |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming or Function? | Excel Discussion (Misc queries) | |||
WORKSHEET FUNCTION or PROGRAMMING. | Excel Worksheet Functions | |||
Function/Programming help with excel | Excel Discussion (Misc queries) | |||
Programming function keys in Excel | Excel Discussion (Misc queries) | |||
Programming a Function in VB | Excel Discussion (Misc queries) |