Countifs Formula not providing results

[Pancakey]

Hello,

I have having trouble having a result populate in column C. I have the formula entered but it is not populating anything.

Formula for C25:
=COUNTIFS('Purchase Order'!K:K,B27,'Purchase Order'!C:C,">="&StartDate,'Purchase Order'!C:C,"<="&EOMONTH(StartDate,11))

I have a drop-down menu entered in column K, however I am thinking of entering a formula for it. Either way, I am not sure what the problem is on why the results is not populating for the above formula.

Formula for C4 on the Purchase Order tab:
=VLOOKUP(E4,'PO Line Data UPD 11-28-23'!$1:$1048576,5,FALSE)

 

[Pancakey]

I have a correction for the above, how would I use the count formula to count the number of cells in a column based on a list of statuses, such as sent, in progress, paid, cancelled?

 

[BigDawg15]

In C25:  =countif(K4:K10,"Sent")

In C25: =countif(k4:K10,"In Progress")

Change ranges four your needs.

 

[Dave Patton]

Adjust the ranges as necessary.
N.B. You can post a concise extract of your sheet(s) with the forums tool named XL2BB.

T202312a.xlsm
	A	B	C	D	E
1			From	To
2		Sent	01-Dec-23	30-Nov-24	2
3	or	Sent	01-Dec-23		2
4
1d

Cell Formulas
Range	Formula
D2	D2	=EOMONTH(C2,11)
E2	E2	=COUNTIFS('Purchase Order'!K2:K1000,B2,'Purchase Order'!C2:C1000,">="&C2,'Purchase Order'!C2:C1000,"<="&D2)
E3	E3	=COUNTIFS('Purchase Order'!K2:K1000,B2,'Purchase Order'!C2:C1000,">="&C2,'Purchase Order'!C2:C1000,"<="&EOMONTH(C3,11))