LinkBack URL
About LinkBacks
Hi" I need to figure out a way to count multiple columns with a given criteria & display total count in a table, please see attached file... any help suggestions will be appreciated.
Hi" I need to figure out a way to count multiple columns with a given criteria & display total count in a table, please see attached file... any help suggestions will be appreciated.
Perhaps something like this:
adjust ranges as required.
Please Login or Register to view this content.
Be careful of erroneous spaces after your keywords, i.e. "Development ".
Docendo discimus.
Thanks for the quick response, This works OK, but one question ? Where does it take the given date to consideration ?? I need Changes counted by Support group>environment>given date (Ex:Today), let me know if this is possible...
Where in your sheet will the "given date" be displayed?
Please see the attached file below...
Last edited by adriandefry; 07-27-2012 at 04:14 PM.
Here is the modified excel for clarity.. Thanks
Not what I meant...
Do you only want to count the changes occurring on the current day (Today), or do you want to supply another date to count for?
[Edit] - your new sheet answers the question.
Try this:
Please Login or Register to view this content.
for some reason the above returns false counts, OK the filelds that I am intrested in are Support Group Name/
Environment/Startdate,
Hello,
Any ideas why it returns false counts ? all I need is to know how many changes per given day(startdate)by team & environment.. Thanks in advance...
Hi Adrian,
My formula was counting the Support Group Name/Environment combinations that were active between the respective start date - end date ranges. What were the false counts you saw?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks