Need help with a formula!

  • Thread starter Thread starter Cesar Urquidi
  • Start date Start date
C

Cesar Urquidi

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
 
Hello Eduardo,
It worked just like I needed...
Thank you very much Sr.!!!

Cesar Urquidi
 
Back
Top