K kanap New Member Feb 25, 2013 #1 I want to search the values in 2 columns and add as count in the other column of the table [pre] Code: Table1 : Column 1: Status , Column 2: Severity New S1 Open S2 Close S3 S3 [/pre]
I want to search the values in 2 columns and add as count in the other column of the table [pre] Code: Table1 : Column 1: Status , Column 2: Severity New S1 Open S2 Close S3 S3 [/pre]
Luke M Excel Ninja Staff member Feb 25, 2013 #2 If you have XL 2007+, you can use COUNTIFS. If not, a SUMPRODUCT structure like so: =SUMPRODUCT((Array1=Criteria1)*(Array2=Criteria2)) will do the trick.
If you have XL 2007+, you can use COUNTIFS. If not, a SUMPRODUCT structure like so: =SUMPRODUCT((Array1=Criteria1)*(Array2=Criteria2)) will do the trick.
K kanap New Member Feb 26, 2013 #3 Hi Luke, I tried this and not working =SUMPRODUCT(Severity)*(Status="Open") I have other table with following: Table2: Severity1 Severity2 Severity3 Severity 4 New Open Closed So from the above table 1 i need to search all open for Sev1 and put the total sum under new.
Hi Luke, I tried this and not working =SUMPRODUCT(Severity)*(Status="Open") I have other table with following: Table2: Severity1 Severity2 Severity3 Severity 4 New Open Closed So from the above table 1 i need to search all open for Sev1 and put the total sum under new.
