Need help with a formula!

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
 
E

Eduardo

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
 
C

Cesar Urquidi

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

Cesar Urquidi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a wild card * with Sumproduct 4
If Function with Multiple Conditions 6
Formula Help 2
my latest C++ excel OLE automation code 4
Can an If statement return a formula for false? 1
formula need a fix. HELP! 1
I have a formula problem that I can't figure out 2
count if colum begins with 5

Top