Thread: count values from same dates in list (without VBA)

Hi,

I'd like to extract (& count) the status value for a specific date range from a list with dates & status (several dates can be the same but with different/same status).

It's clearer with the attachment

Is this possible with formula's and not with VBA code (the excel sheet is shared)...

Thanks
B

Here, try this in F4 and pull right and down:

=SUMPRODUCT(--($A$4:$A$20=$E4);--($C$4:$C$20=F$3))