Count values from cells in different columns
Hi again,
I have another question concerning an Excel Spreadsheet.
I want to count the members of each organization after the change. I assume I must get the sum of each org out of column A for those that do have "no change" in column B, plus the sum of that org in column B.
The Example is attached.
Thank you much for helping me out.
This forum is awesome and I'll recommend the website!
| Attachment | Size |
|---|---|
| Example.xlsx | 9.48 KB |
Count values from cells in different columns
Hi Julia,
To get number of members of ABC after change (without "no change"):
=COUNTIFS($B$2:$B$23;"<>no change";$A$2:$A$23;"ABC")
To get members of other organizations, change "ABC" appropriately.
If there are too many organizations to change them manually, create pivot table with organization as row field, count of organization as summary field, and NewOrg as filter where you exclude "no change"
also
Also when I try to use the formula in the original spreadsheet it tells me there is an error in the formula.
i'm not sure if that's all I need
Thank you for your answer.
Correct me if I'm wrong, but doesn't your formula exclude those people that now moved into the organization?
I need to count those that have ABC in A while "no change" in B
+
those that have ABC in B.
From how I understand your formula, just the first part is covered. But again I'm not very good at excel.
Could you please explain?
Thanks a lot!
Julia
Correction
Ah, yes. Here is formula for ABC:
=COUNTIFS($B$2:$B$23;"<>no change";$A$2:$A$23;"ABC")+COUNTIF($B$2:$B$23;"ABC")
For others (DEF, GHI, JKL), amend formula accordingly (at two places in formula).
If it returns an error, change semicolon to comma. It could be due to your computer/Excel settings.