Simple Help I am sure!!!

scwnrdr

New Member
Joined
Jan 19, 2004
Messages
3
In sheet one I need a function refering to sheet 2. I need to know the number of time the word "blue" shows up in column "a" and the word "stock" shows up in colum "b" Now the formula need to refer to the number of times each word shows up in the same row.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi scwnrdr:

Welcome to Mrexcel Board!

Why not share with us ... What do you need this formulation for? What have you tried?

Anyway, try ...

=COUNTIF(Sheet2!A:A,"blue")&" and "&COUNTIF(Sheet2!B:B,"stock")

Would this do?
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

Like Yogi said, share...

Care to post some of your sheet? You can use Colo's Awesome HTML Maker, the link to which can be found at the bottom of the page.

Hope that helps,

Smitty
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
scwnrdr said:
Now the formula need to refer to the number of times each word shows up in the same row.

=SUMPRODUCT(--(SHEET2!A1:A100="A"),--(SHEET2!B1:B100="STOCK"))
 

scwnrdr

New Member
Joined
Jan 19, 2004
Messages
3

ADVERTISEMENT

I work for a bicycle manufacturer and I keep track of our inventory with this excel sheet. Colum a is the colors and colum b is the customer. Sometimes colum a is a backorder or I could just count colors. I tried both of the suggestions and they are not exactly what I am looking for. I will try and explain better. Say in column a I have 10 "blue" in column b 4 of the rows also show "stock" I need the formula to give a total number of rows which say blue and stock in them. Thank you for being so kind and helping me with my excel infantcy!
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
scwnrdr said:
I work for a bicycle manufacturer and I keep track of our inventory with this excel sheet. Colum a is the colors and colum b is the customer. Sometimes colum a is a backorder or I could just count colors. I tried both of the suggestions and they are not exactly what I am looking for. I will try and explain better. Say in column a I have 10 "blue" in column b 4 of the rows also show "stock" I need the formula to give a total number of rows which say blue and stock in them. Thank you for being so kind and helping me with my excel infantcy!

change "A" to "blue"
Book1
ABCD
1bluestock3
2blue
3bluestock
4blue
5bluestock
Sheet1
 

scwnrdr

New Member
Joined
Jan 19, 2004
Messages
3
Brian from Maui...you seem to get what I am trying to do and I really apreciate the help. After much agony I finally got it right and now have what I need.

Thank you
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,888
Messages
5,766,948
Members
425,389
Latest member
Naresha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top