Problem with SUMPRODUCT
for a single criteria, you could use SUMIF
=SUMIF(Mon!B$1:B$10000,TIME(8,0,0),Mon!H$1:H$10000 )
to use SUMPRODUCT, try this
=SUMPRODUCT(--(Mon!B$1:B$10000=TIME(8,0,0)),Mon!H$1:H$10000)
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"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.
|