Multiple columns using countifs

Closed
jclegg42002 Posts 1 Registration date Saturday 6 September 2014 Status Member Last seen 6 September 2014 - 6 Sep 2014 à 07:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Sep 2014 à 02:11
I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N
VZN WIN/PENDING/LOST

I would like to use a formula to check if 'VZN' =countifs(A:A,"VZN", N:N,"PENDING",N:N, "WON") to tally up the current bids instead of just using

=countif(a:A,"vzn") which counts every single entry I have submitted, I have plans down the line for this and would love if someone could help me knock this out! I had working once and tried mocking it to my other vendors and they were not outputting the correct data... so needless to say im a bit stumped.

Basically, 'IF' VZN, go to column N check for pending/won entries

Thank you all so much for your professional help!!

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
7 Sep 2014 à 02:11
suppose last row is 10

=sumproduct((A2:A10="VGN")*(N2:N10="WON")*(N2:N10="PENDING"))