Hi forum,
Here we go... I have another headache...
I have a column O called Call Score for which I only want to count scores that are less than 70, but only if the date column N is 4/1, 4/2, 4/3, 4/4 and 4/5.
There, I am clueless...
Hi forum,
Here we go... I have another headache...
I have a column O called Call Score for which I only want to count scores that are less than 70, but only if the date column N is 4/1, 4/2, 4/3, 4/4 and 4/5.
There, I am clueless...
Last edited by bmunoz64; 04-05-2009 at 08:24 PM.
Try
=COUNTIFS(scores,">70",dates,">="&DATE(2009,4,1),dates,"<="&DATE(2009,4,5))
This looks similar to the help I require. May I ask what I'd type should I want it to select the same but for the entire month of May? (rather than the individual dates specified above).
This is absolutely awesome! It worked!
Forum moderators, this is the best help I have ever had in my professional career.
I have learned more about Excel in just 3 weeks than my entire work years. Thanks again!!!
Try =COUNTIFS(scores,">70",dates,">="&DATE(2009,5,1),dates,"<="&DATE(2009,5,31))
scores in small caps is actually a column
dates in small caps is actually a column as well
good luck!
Awesome, thanks ...and sorry about using the back of your thread to ask.
no problem... I ask a lot of questions to the forum so I think it was nice to help someone figure out those formulas...
Fyi - Microsoft website has a how-to section that is Ok. It helps identify what formula(s) are good for waht you want to accomplish. But then to find out the content of the argument, after you've tried figuring it out on your own, your best bet is the forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks