count if for 2 conditions

  • Thread starter Thread starter AwesomeSean
  • Start date Start date
A

AwesomeSean

I am trying to create a formula and have had no success in checking 2
different colums for certian text. If both colums/boxes match, then 1 if not
then don't count. I have tried sumiif, count if, counta, sumproduct with no
luck. Does anyone have any ideas?
 
If you are using Excel 2003 I believe the only one that will work is
sumproduct; but it can do pretty much anything, however, it can be a
little tricky. Provide some more information please.

Ken
 
I actually figured it out. Here is what I did.
=SUMPRODUCT((Monday!$C2:$C154="Scheduled")*(Monday!$D2:$D154="Rescheduled"))

All I wanted to do was have excel return me a 1 if it was true and do
nothing if it was false so with this i am looking in 2 different colums.
Column A should say "scheduled" and column b should say "Rescheduled" and if
they do then count 1

I tried all day to figure this out and actually what i was doing wrong is i
was trying to look at the whole column which this formula will not do.
As soon as i gave it a range, BINGO. It worked. I hope this helps someone
else out having this same concern.
 
Back
Top