How to compare two columns and return the sum?

Asked

Viewed 99 times

0

Personal talk,

I have the following table below, what I want is that it adds the Price (Column D) of all books with the Situation (Column AND) "Sold".

I know I can do with the PROCV function. But I am already on time studying this function and so far I have not been able to implement in my table. If anyone can help me, I’d be extremely grateful.

Plus, I appreciate the attention and understanding of the problem.

Minha Tabela

excel windows table spreadsheets office

1 answer

-1


Take a look at this function SOMASE Here

=SOMASE(E2:E22, "Vendido", D2:D22)

  • Wow, easier than I thought. Thank you very much, Willys!

Browser other questions tagged excel windows table spreadsheets office

You are not signed in. Login or sign up in order to post.