Get value by taking into account two columns

Asked

Viewed 62 times

0

I’m trying to get the number of anti-virus licenses per department and I can’t come up with a formula that can return this information to me.

inserir a descrição da imagem aqui

Basically, I want to get how many licenses there are in the department "Shopping".

=CONTAR.SE(Gestão!B3:B1000; "Compras")

This formula is to get the number of computers in the Purchasing Department. Now I want to get the number of users in the purchasing department who have anti-virus license.

=CONTAR.SE(Gestão!B3:B1000; "Compras") + CONTAR.SE(Gestão!H3:H1000; "X")

I tried this formula, but it obviously doesn’t work.

The result would be that in Purchases there are 2 anti-virus licenses.

excel

  • Be clearer in your question,.

  • I think the function CONT.SE can help you. Put on D1: =CONT.SE(A2:A5;"Compras")

  • I just updated! I’m sorry! @KALIBBAN

2 answers

2


Provide the data in column "H". But I believe this way it works: =CONT.SES(Gestão!B3:B1000; "Compras";Gestão!H3:H1000; "X")

  • It worked! Thank you! I tried it earlier with this formula and for some reason it didn’t work

0

Can solve with the following formula:

=CONT.SES(Gestão!B3:B1000;"Compras";Gestão!H3:H1000;"<>"&"")

Browser other questions tagged excel

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