Problem with SUMPRODUCT
Try
=SUMPRODUCT(--(Mon!B$2:B$10000=TIMEVALUE("8:00 AM")),Mon!H$2:H$10000)
Please note that if the time entry is 08:00:01 still it is displayed as 8:00
AM but the formula will not count. To handle that use
=SUMPRODUCT(--(HOUR(Mon!B$2:B$10000)=8),Mon!H$2:H$10000)
If this post helps click Yes
---------------
Jacob Skaria
"Sasikiran" wrote:
Dear,
I have the data in a sheet "Mon" and i would require to calcuate the total
of the numbers in column H if the corresponding value in column B is 8:00 AM.
I am trying to use the below formula. Please help me in correcting the same.
=SUMPRODUCT((Mon!B$2:B$10000=--"8:00 AM")*(Mon!H$2:H$10000=--1))
Thanks in advance.
|