Need Excel Multi-Condition Formula

  • Thread starter Thread starter Pat Crosby Hampton
  • Start date Start date
P

Pat Crosby Hampton

Hi!
I need a formula that will count or sum based of the cell
content meeting a date required. Specifically, there are
3 columns involved. Column 1 contains a Priority (High,
Med, or Low). Column 2 contains a Functional Area (Rules,
Fees, etc.). Column 3 contains a date. I want it to
count the occurrences of Column 1 = High, Column 2 =
Rules, when column 3 is greater than 7/1/2003. Is this
possible? I've been trying to do it with a Nested
Function... =SUM(IF('Logged Issues'!
$M$2:$M$2000>"7/24/2003",IF('Logged Issues'!
$I$2:$I$2000="Client/Screen",IF('Logged Issues'!
$D$2:$D$2000="High",1,0))))

Help!!!!
 
There are potentially two minor problems with your
function.

1. I don't think Excel will recognize "7/24/2003" as a
date. Try DATE(2003,7,24) instead.

2. You must enter this function as an array function. You
can do this by, instead of pressing <ENTER> when you edit
the formula, press <CTRL>-<SHIFT>-<ENTER>.

Hope this helps,
Ryan
 
How about

=SUMPRODUCT(('logged issues'!$M$2:$M$2000>"7/24/2003")*
('logged issues'!$I$2:$I$2000="Client/Screen")*('logged
issues'!$D$2:$D$2000="High"))

Lance
 
Back
Top