chech if two or more cells = and return a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
dose any one know how to check if two ore more cells are true and return a
value
e.g. if a1= 10 and a2= 20 then return a value or what ever it needs to be
 
Hi there Max
I was browsing through the Microsoft Office Discussions Group and noticed
that you were able to help someone out with an Excel 2003 question similar to
what I have for you.

Here is my question:

I have a resume Excel spreadsheet in which Col. A lists the “states†in
America (i.e. CA, AK, MI, ME, etc …) Column B states if the job position is
“Union†and Column C states if the job position is “Non Unionâ€. What I would
like to do is to “COUNT†the number of “Union†and “Non Union†jobs in ANY
particular state. Could you please assist me with that?. I’d like to graph it
out.

Thank you and have a great day.

With sincere respect,

Tom
 
:

Hi there Max

I was browsing through the Microsoft Office Discussions Group and noticed
that you were able to help someone out with an Excel 2003 question similar to
what I have for you.

Here is my question:

I have a resume Excel spreadsheet in which Col. A lists the “states†in
America (i.e. CA, AK, MI, ME, etc …) Column B states if the job position is
“Union†and Column C states if the job position is “Non Unionâ€. What I would
like to do is to “COUNT†the number of “Union†and “Non Union†jobs in ANY
particular state. Could you please assist me with that?. I’d like to graph it
out.

Thank you and have a great day.

With sincere respect,

Tom
 
Think using a pivot table is quite ideal for your instance, Tom.

Assuming your data in cols A and B,
with headers in row1, eg:

States Job
CA Union
AK Non Union
MI Non Union
ME Union
CA Non Union
etc

Select cols A and B, click Data > Pivot table
Click Next > Next

In step 3 of the wiz, click Layout
Drag n drop States in ROW area
Drag n drop Job in COLUMN area
Drag n drop Job in DATA area
(it'll appear as Count of Job)
Click OK > Finish, That's it.

Hop over to the PT sheet for the results

It'll look something like this:

Count of Job Job
States Non Union Union Grand Total
AK 2 1 3
CA 1 2 3
ME 2 1 3
MI 1 2 3
etc

viz it gives you the required unique listing of all the States,
and the breakdown counts of union/non union for each state

For charting, you could tinker by just right-clicking on any cell inside the
pivot table > choose PivotChart. This would instantly yield a chart linked to
the pivot table that you can further dress up to taste.
 
Back
Top