sumifs criteria
 

I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714)
(Criteria range, criteria, sum range)

The criteria range isan entire month of hourly timestamps and I am trying to
sum a specific time (ie 12:00 pm) for the entire month. I have tried
converting all of the dates to the excel number ie 39639.50 etc, but I cannot
make the function sum even one day using the wildcard symbols "*" or "?".

I have tried many different versions ofthis formula to no avail. please help

-A

sumifs criteria
 

=SUMPRODUCT(--(HOUR($A$1:$A$714)=12),--(MINUTE($A$1:$A$714)=0),--(SECOND($A$1:$A$714)=0),($B$1:$B$714))
--
HTH,
Barb Reinhardt



"Ebisu-A" wrote:

I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714)
(Criteria range, criteria, sum range)

The criteria range isan entire month of hourly timestamps and I am trying to
sum a specific time (ie 12:00 pm) for the entire month. I have tried
converting all of the dates to the excel number ie 39639.50 etc, but I cannot
make the function sum even one day using the wildcard symbols "*" or "?".

I have tried many different versions ofthis formula to no avail. please help

-A

sumifs criteria
 

This is probably an easier one

=SUMPRODUCT(--(MOD($A$1:$A$714,1)=0.5),($B$1:$B$714))
--
HTH,
Barb Reinhardt



"Ebisu-A" wrote:

I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714)
(Criteria range, criteria, sum range)

The criteria range isan entire month of hourly timestamps and I am trying to
sum a specific time (ie 12:00 pm) for the entire month. I have tried
converting all of the dates to the excel number ie 39639.50 etc, but I cannot
make the function sum even one day using the wildcard symbols "*" or "?".

I have tried many different versions ofthis formula to no avail. please help

-A

sumifs criteria
 

Thank you Barb.

This formula worked perfectly for this purpose-

Ebisu-A

"Barb Reinhardt" wrote:

=SUMPRODUCT(--(HOUR($A$1:$A$714)=12),--(MINUTE($A$1:$A$714)=0),--(SECOND($A$1:$A$714)=0),($B$1:$B$714))
--
HTH,
Barb Reinhardt



"Ebisu-A" wrote:

I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714)
(Criteria range, criteria, sum range)

The criteria range isan entire month of hourly timestamps and I am trying to
sum a specific time (ie 12:00 pm) for the entire month. I have tried
converting all of the dates to the excel number ie 39639.50 etc, but I cannot
make the function sum even one day using the wildcard symbols "*" or "?".

I have tried many different versions ofthis formula to no avail. please help

-A