Count description base on the DATE

**jasond1992** · 05-04-2021, 02:24 AM

Good day just asking for a help I don't know what formula I need to use to count all the description base on the date. Please see attached images for the expected result. Thanks in advance.

DATA
Data.PNG

Expected Result
Expected Result.PNG

**kvsrinivasamurthy** · 05-04-2021, 02:39 AM

In C13 then copied

=SUMPRODUCT(($C$2:$G$9<>"")*($A$2:$A$9=C12))

**samba_ravi** · 05-04-2021, 02:40 AM

c13=SUMPRODUCT(($C$2:$G$9<>"")*($A$2:$A$9=C$12))
try this, copy and paste it in D13

**jasond1992** · 05-04-2021, 02:52 AM

Thank you so much.

Count description base on the DATE

LinkBack

Thread Tools

Rate This Thread

Display

Count description base on the DATE

Re: Count description base on the DATE

Re: Count description base on the DATE

Re: Count description base on the DATE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count all the specific Description base on name

[SOLVED] Data base has data in two lines ( time & ending of crime description)

[SOLVED] Drop List with a description but once chosen description disappear

Date format description

Summing by Description and Date

Count a series of number with different types/description

Count and compute rows of data with different catagories and description 2003 format

Bookmarks

Bookmarks

Posting Permissions