Multiple columns using countifs

Closed
jclegg42002 Posts 1 Registration date Saturday September 6, 2014 Status Member Last seen September 6, 2014 - Sep 6, 2014 at 07:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 7, 2014 at 02:11 AM
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 June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 7, 2014 at 02:11 AM
suppose last row is 10

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