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
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!!
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!!
Related:
- Multiple columns using countifs
- Tweetdeck larger columns - Guide
- Allow multiple downloads chrome - Guide
- Photoshop multiple selections - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete multiple files on mac - Guide
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
Sep 7, 2014 at 02:11 AM
suppose last row is 10
=sumproduct((A2:A10="VGN")*(N2:N10="WON")*(N2:N10="PENDING"))
=sumproduct((A2:A10="VGN")*(N2:N10="WON")*(N2:N10="PENDING"))