SumProduct

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

Guest

Dear all

I need your help please.

I need to sum the values of a columm with a condition of the other columm

ex:
A B
Blue 100
Red 200
Blue 150
Blue 180

So what I need is the sum of columm B of the "blue" in columm A

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

<ASK> How to add columm more than the default columm IV 3
=PRODUCT 6
Determine the highest Matrix value (Office - Excel) 2
How I add a name to my group 2
Putting In Coma's Need Major Help 8
HOW DO I ADD A NAME TO A GROUP 1
Delete rows that start with CCNUXXXX with macro 5
Copy cells in a determined order 3

Back
Top