i want to do countifs multiple criteria from multiple sheets .please help me.
i want to do countifs multiple criteria from multiple sheets .please help me.
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thankyou for quick response .Here i have attached sample file.
In C5 copied across and down:
=COUNTIFS(INDIRECT($A$2&"!$A$3:$A$10"),$B5,INDIRECT($A$2&"!$D$3:$D$10"),C$4)
wow its working ..thankyou very much!!!!!!
Excepting one more help..hope by this i will be able to understand countif with indirect function...thankyou
i need to filter data between two date in same sample...Thanks in advance.
Start date in E1, end date in E2:
=COUNTIFS(INDIRECT($A$2&"!$b$3:$b$10"),$B5,INDIRECT($A$2&"!$e$3:$e$10"),C$4,INDIRECT($A$2&"!$A$3:$A$10"),">="&E$1,INDIRECT($A$2&"!$A$3:$A$10"),"<="&E$2)
I solved it by adding all data on 1 worksheet.
Adding year and month (with a formula).
After that a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Its working ..Thankyou
I am unable to search value form entire worksheets in google sheets.I am trying to search just by CTRL+F and find value but its not working form entire worksheet/
please help...
got my answer ..there is some keyboard error
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks