countif or sumif formula tricky one

Hi Experts excel 2007

I am trying to count the number of results between set dates..I have the following table.

col A.         Col B. Case 1.       Col C Result
1.                             6.                  Sum of values falling into 1-3 cat based on colA
2.                             5
3.                             8
4.                             1.                  Sum of val <4 based on col A
5.                             2
6.                             9
7.                            10
Who is Participating?
gowflowConnect With a Mentor Commented:
ok here it is you should use SUMIFS

for >=1 and <=3 this is the formula

for<4 this is the formula

and you can see it in the attached file.
a bit not clear
counting results between set dates but see no dates here.
Sum of values falling into 1-3 cat based on colA
of what of Col B ?

 Sum of val <4 based on col A
also not clear

Col A is figures 1,2,3,4 etc.... ? or  ? what is the point for ?

can you post a sample workbook ?
route217Author Commented:
Hi gowflow

question1. Sum of values falling into 1-3 cat based on colAof what of Col B ?
answer. 6+5+8=19...
I am using col a as a ref table.

Also the count would be 3 records. ..
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Rgonzo1971Connect With a Mentor Commented:

pls try


Open in new window


Open in new window

route217Author Commented:
Gowflow excellent feedback. would I do the count..
Well read it again and although you said SUM of values for <4 but then you give the result of 3 then it is no more a SUMIFS but a COUNT

so for <4

You can use them without the S at the end as well but I prefer these as they open the door for multiple criteria if and when needed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.