Countifs formula

[manoj_arsul]

Hi
I want program for below formula

=SUM(COUNTIFS(Data!A:A,{"Assigned","Pending","Pending - Not Assigned"},S:S,"="&TODAY()))

 

[GazNicki]

Sorry, this doesn't give much information.

Please could you describe your speadsheet and what you wish it to do?

 

[manoj_arsul]

Sorry, this doesn't give much information.

Please could you describe your speadsheet and what you wish it to do?

Hi @GazNicki


Thanks for replying

It is the formula for count of cell in column for below condition
1. Filter A for Assigned pending & Pending - Not assigned
2. Filter for S coloumn for today (date)

Out Put : Count of cell in column (one)

 

[Aladin Akyurek]

If you want to run this formula by means of a vba code, says so. Otherwise, you need to explain what issue you have with it, double counding perhaps?

 

[Joyner]

Hello try:

=SUM(COUNTIFS(Data!A:A,{"Assigned";"Pending";"Pending - Not Assigned"},S:S,TODAY()))

 

[Joyner]

Hello try:

=SUM(COUNTIFS(Data!A:A,{"Assigned";"Pending";"Pending - Not Assigned"},S:S,TODAY()))

Hello Aladin,

I think the issue was the use of the comma versus the semicolon. I got that from one of your posts, and I don't really understand in these cases when you use a comma or a semicolon, I believe I have see you use both in the same formula. Can you explain when you use which?

Thanks

 

[Aladin Akyurek]

Hello Aladin,

I think the issue was the use of the comma versus the semicolon. I got that from one of your posts, and I don't really understand in these cases when you use a comma or a semicolon, I believe I have see you use both in the same formula. Can you explain when you use which?

Thanks

That issue arises when we have 2 sets of multiple value conditions, not when we have 1 set as here.

The OP references column A of the sheet Data, while column S of the formula sheet. This could be the problem.

Book1
	A	S	T
1
2			3
3	assigned	7/24/2018
4		7/24/2018
5	pending	7/23/2018
6	Pending - Not Assigned	7/24/2018
7	assigned	7/24/2018
8
9
Data

In T2 I have:

=SUM(COUNTIFS(Data!A:A,{"Assigned","Pending","Pending - Not Assigned"},Data!S:S,"="&TODAY()))

All column references are to Data.

If you replace the formula with one figuring semi-colon in-between { and }, we would get the same result.

 

[manoj_arsul]

Hi @ Aladin Akyurek

Yes , I was missed the word VBA

when I run this formula in VBA then occur & ie. complex error : Expected : End of statement

 

[Joyner]

Okay, the first time I tried the formula with the commas itwasn’t working, now the formula appears to be working whether I use a comma ora semicolon. So as I understand it, the original formula posted by the OP, should work.

Edit - I see you addressed this above Aladin, Thanks

 

[Aladin Akyurek]

Hi @ Aladin Akyurek

Yes , I was missed the word VBA

when I run this formula in VBA then occur & ie. complex error : Expected : End of statement

Check out the sheet names... By the way, I don't see why you would want vba to run this formula.