How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Michael Hannigan Your Own Question
Michael Hannigan
Michael Hannigan, Office Specialist
Category: Microsoft Office
Satisfied Customers: 11653
Experience:  25+ Years Experience in Computers and Electronics. Microsoft Certified MCSE, MCDBA, MCP, Microsoft Partner
23511658
Type Your Microsoft Office Question Here...
Michael Hannigan is online now
A new question is answered every 9 seconds

Help in Excel I have a large table, 3 columns, many rows.

Resolved Question:

Help in Excel: I have a large table, 3 columns, many rows. I want to query the table, asking "if column 1 contains DOG, multiply the same row values in column 2 & 3". Column 1 will have DOG repeated many times, and I want the sum of these occurrences (the sum of the products of columns 2*3 for each DOG).
Thanks!
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  replied 5 years ago.

XXXXX XXXXXnigan :

Hello. I can assist you with your question.

JACUSTOMER-o980kf6e- :

great...thanks

JACUSTOMER-o980kf6e- :

do you need any more info from me or are you working on a formula?

XXXXX XXXXXnigan :

What I would do... just did this earlier is keep it simple.

XXXXX XXXXXnigan :

So I would create another column, which you will later hide.

XXXXX XXXXXnigan :

And in that column test for the condition to decide the falue

XXXXX XXXXXnigan :

So in the new column you can have =if(a1="DOG"),(a2*A3,0)

JACUSTOMER-o980kf6e- :

ok...just thinking about this

XXXXX XXXXXnigan :

ok

JACUSTOMER-o980kf6e- :

hmmm...I think that worked. I was expecting something far more complex

XXXXX XXXXXnigan :

There are much more complex ways to do it.

XXXXX XXXXXnigan :

Did you want to go that route?

XXXXX XXXXXnigan :

They break very easily.

XXXXX XXXXXnigan :

There isn't really a "moderately complex" way

XXXXX XXXXXnigan :

But if it does do what you need it to... and it's easy to understand, that's what I would chose.

JACUSTOMER-o980kf6e- :

well I guess one day it might be nice to learn..but simple is good. You helped me get over the stumbling block...Thanks.

Michael Hannigan and 3 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions