LinkBack URL
About LinkBacks
Hi All,
=COUNTIFS(Sheet1!D:D,Sheet2!$C$4,Sheet1!AB:AB,B7,Sheet1!AA:AA,{"Validation Pending","In-Progress"})
in the above formula, it works if dont use {}. i did Countifs+countifs to get the value.
someone told me that {} also works....
please help
Hi All,
=COUNTIFS(Sheet1!D:D,Sheet2!$C$4,Sheet1!AB:AB,B7,Sheet1!AA:AA,{"Validation Pending","In-Progress"})
in the above formula, it works if dont use {}. i did Countifs+countifs to get the value.
someone told me that {} also works....
please help
you need to sum, the result:
=sum(countif(...))
Entia non sunt multiplicanda sine necessitate
Sum worked earlier...but I want to understand why { } is nt working..I have seen on this forum that it works when we give criteria in { }
When you use an array of criteria, an array of results is returned, therefore you must SUM the result as shg said. In case it was unclear:
=SUM(COUNTIFS(Sheet1!D:D,Sheet2!$C$4,Sheet1!AB:AB,B7,Sheet1!AA:AA,{"Validation Pending","In-Progress"}))
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Got It....Thanks a lot....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks