Excel array formula help please

  User-67C15525-3DBE-41EF-B48A981FE25748D2 16:43 26 Jan 2007
Locked

I’m trying to create a spreadsheet that captures historical monthly stats.

Column A contains the name of the item.

In column F I have the date an item has been received by myself.

In column K I have the date an item is then forwarded on.

In cell D4 I have a date (first day of a month)

In cell D5 I have a date (last day of a month)

The spreadsheet is a work in progress. Items may get forwarded the same month or several months later.

I will never use more than 5000 rows. I start recording items from row 13 onwards. Each entry remains in the row it is originally entered in.

I want a formula to return a sum of the number of outstanding items at the end of a particular month waiting to be forwarded on as follows:

If there is no date in column K (i.e. the item has been received by myself but has not been forwarded on), or if the forwarding date in column K is not between or equal to the dates in cells D4 & D5 I want to sum the number of items outstanding at the end of the month for that particular month.

This figure should then never change as the year progresses.

Does this make sense?

Tia for any help.

  VoG II 17:00 26 Jan 2007

If I understand correctly

=COUNTBLANK(K13:K20)+COUNTIF(K13:K20,"<"&D4)+COUNTIF(K13:K20,">"&D5)

which is NOT an array formula.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?