HI all:
Can i know why this equation is not working?
I would like to sum column B if Column A is greater than 23 and less than 6.
The greatest number in Column A is 24 (It is 24 hours time).
I know the problem is with
What i would like to know is what is wrong with it.
Thanks in advance for the help
Can i know why this equation is not working?
Code:
=SUMIF(A1:A31,( ">23")*("<6"),$B$1:$B$31)
I would like to sum column B if Column A is greater than 23 and less than 6.
The greatest number in Column A is 24 (It is 24 hours time).
I know the problem is with
Code:
( ">23")*("<6")
Thanks in advance for the help