Hello,
I have a large worksheet with data (columns "A", "B", "C", "D" "E", "F" &
"G").
(I'm using only a few records for reference).

Here are the columns:

Quote Quote Quote STD STD ENG ENG
Type Number Status OPEN CLOSED OPEN CLOSED
STD Q090001 CLOSED formula formula formula formula
ENG Q090002 CLOSED
STD Q090003 CLOSED
STD Q090004 OPEN
STD Q090005 CLOSED
ENG Q090006 CLOSED
ENG Q090007 CLOSED
STD Q090008 CLOSED
STD Q090009 OPEN
ENG Q100001 OPEN
STD Q100002 CLOSED
STD Q100003 CLOSED
ENG Q100004 OPEN
STD Q100005 OPEN
STD Q100006 OPEN

I need to count how many "STD" & "ENG" quotes are "OPEN" & "CLOSED"
I need a formula in columns "D", "E", "F" & "G".

Is there a formula for this?

Help please!!!

Thank you,
Cesar Urquidi

Hi,

=SUMPRODUCT((A14:A17="STD")*(B14:B17="Open"))
=SUMPRODUCT((A14:A17="STD")*(B14:B17="Closed"))
=SUMPRODUCT((A14:A17="ENG")*(B14:B17="Open"))
=SUMPRODUCT((A14:A17="ENG")*(B14:B17="Closed"))

change range to meet your needs


"Cesar Urquidi" wrote:

Hello,
I have a large worksheet with data (columns "A", "B", "C", "D" "E", "F" &
"G").
(I'm using only a few records for reference).

Here are the columns:

Quote Quote Quote STD STD ENG ENG
Type Number Status OPEN CLOSED OPEN CLOSED
STD Q090001 CLOSED formula formula formula formula
ENG Q090002 CLOSED
STD Q090003 CLOSED
STD Q090004 OPEN
STD Q090005 CLOSED
ENG Q090006 CLOSED
ENG Q090007 CLOSED
STD Q090008 CLOSED
STD Q090009 OPEN
ENG Q100001 OPEN
STD Q100002 CLOSED
STD Q100003 CLOSED
ENG Q100004 OPEN
STD Q100005 OPEN
STD Q100006 OPEN

I need to count how many "STD" & "ENG" quotes are "OPEN" & "CLOSED"
I need a formula in columns "D", "E", "F" & "G".

Is there a formula for this?

Help please!!!

Thank you,
Cesar Urquidi

Hello Eduardo,
It worked just like I needed...
Thank you very much Sr.!!!

Cesar Urquidi

"Eduardo" wrote:

Hi,

=SUMPRODUCT((A14:A17="STD")*(B14:B17="Open"))
=SUMPRODUCT((A14:A17="STD")*(B14:B17="Closed"))
=SUMPRODUCT((A14:A17="ENG")*(B14:B17="Open"))
=SUMPRODUCT((A14:A17="ENG")*(B14:B17="Closed"))

change range to meet your needs


"Cesar Urquidi" wrote:

Hello,
I have a large worksheet with data (columns "A", "B", "C", "D" "E", "F" &
"G").
(I'm using only a few records for reference).

Here are the columns:

Quote Quote Quote STD STD ENG ENG
Type Number Status OPEN CLOSED OPEN CLOSED
STD Q090001 CLOSED formula formula formula formula
ENG Q090002 CLOSED
STD Q090003 CLOSED
STD Q090004 OPEN
STD Q090005 CLOSED
ENG Q090006 CLOSED
ENG Q090007 CLOSED
STD Q090008 CLOSED
STD Q090009 OPEN
ENG Q100001 OPEN
STD Q100002 CLOSED
STD Q100003 CLOSED
ENG Q100004 OPEN
STD Q100005 OPEN
STD Q100006 OPEN

I need to count how many "STD" & "ENG" quotes are "OPEN" & "CLOSED"
I need a formula in columns "D", "E", "F" & "G".

Is there a formula for this?

Help please!!!

Thank you,
Cesar Urquidi

your welcome, thanks for your feedback

"Cesar Urquidi" wrote:

Hello Eduardo,
It worked just like I needed...
Thank you very much Sr.!!!

Cesar Urquidi

"Eduardo" wrote:

Hi,

=SUMPRODUCT((A14:A17="STD")*(B14:B17="Open"))
=SUMPRODUCT((A14:A17="STD")*(B14:B17="Closed"))
=SUMPRODUCT((A14:A17="ENG")*(B14:B17="Open"))
=SUMPRODUCT((A14:A17="ENG")*(B14:B17="Closed"))

change range to meet your needs


"Cesar Urquidi" wrote:

Hello,
I have a large worksheet with data (columns "A", "B", "C", "D" "E", "F" &
"G").
(I'm using only a few records for reference).

Here are the columns:

Quote Quote Quote STD STD ENG ENG
Type Number Status OPEN CLOSED OPEN CLOSED
STD Q090001 CLOSED formula formula formula formula
ENG Q090002 CLOSED
STD Q090003 CLOSED
STD Q090004 OPEN
STD Q090005 CLOSED
ENG Q090006 CLOSED
ENG Q090007 CLOSED
STD Q090008 CLOSED
STD Q090009 OPEN
ENG Q100001 OPEN
STD Q100002 CLOSED
STD Q100003 CLOSED
ENG Q100004 OPEN
STD Q100005 OPEN
STD Q100006 OPEN

I need to count how many "STD" & "ENG" quotes are "OPEN" & "CLOSED"
I need a formula in columns "D", "E", "F" & "G".

Is there a formula for this?

Help please!!!

Thank you,
Cesar Urquidi