SUMIF doesnt sum, where COUNTIF does count

[jirib]

Hi,

sheet 1, named INPUT:

row C - times (in plain number format, i.e. 1500 for 15:00)
row P - values i need to sum (numbers)
row C - category (words)

sheet 2, named STATS:

I need to achieve a table where header looks like this:
Header: Time From (H) / Time Till (I) / count / sum / volume per category A / volume in category B /
Example: 1500 / 1530 / ??? / ??? / ??? / ???

as for the count, I am doing alright by:

Please Login or Register  to view this content.

but the plain sum returns 0 when like this:

Please Login or Register  to view this content.

the first period where i only need one criteria works fine with:

Please Login or Register  to view this content.

What I ask for:
It doesnt have to be achieved with SUMIF, I was wondering about SUMPRODUCT but I am not familier with it and it seems to me I am just missing a small syntax fix with the SUMIF formula.

thanks,
Jirka

[ChemistB]

I haven't checked your formulas yet but at a glance, I think "=>" needs to be ">=" Same with =<
Did that help?

[jirib]

... "=>" needs to be ">=" Same with =<
Did that help?

Solved, thanks