Hi
I have report with a column B header dates. Column O is status etc open, closed. I need a formula to show with the now function to calculate total opened tickets for the current date.
Hi
I have report with a column B header dates. Column O is status etc open, closed. I need a formula to show with the now function to calculate total opened tickets for the current date.
Try this ...
=SUMPRODUCT((INT(B2:B1000)=TODAY())*(C2:C1000="open"))
Try
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
This worked. I have 2 locations to count separately. The sites are in column A. CAn I know how do I integrate this formula to show the totals seperately?
[=COUNTIFS(B:B,TODAY(),O:O,"open")]
=COUNTIFS(B:B,TODAY(),O:O,"open",A:A,"Site1")
where Site1 is site name
It worked perfect. Thanks man.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks