Is it possible to do sumif for a whole column as range?

Paul H · 04/08/22

Try

=SUMIF(ProductionDate:ProductionDate, TODAY(), Output:Output)

AnthroTim · 04/07/22

Hi @FPMI,

Do you mean something like this?

=SUMIF([Column1]:[Column1], "A", [Column4]:[Column4])

This takes the whole of Column1 as a range to evaluate and the whole of Column4 to add (where they meet the criteria)

Not 100% sure if that's what you mean?

Tim

FPMI · 04/08/22

Here is a screenshot of what I am trying to do. I am using the formula for the summary

I have data encoded every hour. The summary that I would like to show is the sum of the values that has been encoded today.

Paul H · 04/08/22

Try

=SUMIF(ProductionDate:ProductionDate, TODAY(), Output:Output)

FPMI · 04/08/22

Thanks. It worked.

Best Answer