I am trying to write a formula for Excel for Mac that counts the total number of lots that have specific tasks for each phase of the project.
Consolidated
A7 - Project Phase
A8-A11 - Project Task
Kingsbrook (Project)
B:B - Phase
1:1 - Tasks
I need to write a formula in cell Consolidated>C8 that counts the number of values in worksheet Kingsbrook, in the column that matches the value in Consolidated A8 and matching the value in Kingsbrook column B with the value in COlsidated A7.
Last edited by ara.darakjian; 10-30-2023 at 02:45 PM.
Is this for GoogleSheets?
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.
excel for mac
OK. Please update your forum profile to make this clear. Is it 365 that you have?
Yes
ok, thank you
Not having a manually calculated result to use as a guide, this is an untested guess:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you. I have completed a manually calculated version for some guidance if needed.
Does this provide some additional guidance?
Thanx in advance
The formula in post #6 yields the same results as those manually placed in cells C8:C13.
Let us know if you have any questions.
Thank you I will give it a go.
If you want to sum all the values in that same column, how do I edit the cell?
Try the following:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks