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:
=COUNTIFS(INPUT!C14:C2001;">="&H65;INPUT!C14:C2001;"<="&I65)
but the plain sum returns 0 when like this:
=SUMIFS(INPUT!$P$14:$P$2000;INPUT!$C$14:$C$2000;"=>"&$H66;INPUT!$C$14:$C$2000;"=<"&$I66)
the first period where i only need one criteria works fine with:
=SUMIF(INPUT!C14:C2001;"<=" &I65;INPUT!P14:P2000)
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
Bookmarks