CODEWITHSUNDEEP
excelexcel-formula
Teo
Teo

Reputation: 1

How to include cells with today date in SUMIFS formula

I've got raw data in a sheet with columns containing items number, product type, date, etc...

Date format is: 25-01-18 9:20

I'm trying to get a SUMIFS formula to report number of items arrived today.

Like =SUMIFS(Sheet2!G1:G924,Criteria1,Criteria2,etc)

Any idea?

Thanks in advance

Upvotes: 0

Views: 106

Answers (1)

barry houdini
barry houdini

Reputation: 46341

If there are times in the data you can do >= today and < today+1 to count all items on todays date, e.g. if your date/times are in column H this sums column G for all today's items

=SUMIFS(Sheet2!G:G,Sheet2!H:H,">="&TODAY(),Sheet2!H:H,"<"&TODAY()+1)

Or for a simple count of today's items

=COUNTIFS(Sheet2!H:H,">="&TODAY(),Sheet2!H:H,"<"&TODAY()+1)

Upvotes: 1

Related Questions