mingandmong
Active Member
- Joined
- Oct 15, 2014
- Messages
- 339
hi I'm using excel 2016
i have a spreadsheet with the following formula that works, but would like to modify
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"7615") returned value= 290
this counts the number of times 7615 appears in the rows E:E
i would like to change the reference "7615" to cell W1 as this is were i have 7615 also , w2 contains 7616, cell w3 contains 7617
so my formula would look like
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"W1") = 290
[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"W2") = 475
[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"W3") =14
Thankyou[/FONT]<strike>
</strike>[/FONT]
i have a spreadsheet with the following formula that works, but would like to modify
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"7615") returned value= 290
this counts the number of times 7615 appears in the rows E:E
i would like to change the reference "7615" to cell W1 as this is were i have 7615 also , w2 contains 7616, cell w3 contains 7617
so my formula would look like
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"W1") = 290
[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"W2") = 475
[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIF(E:E,"W3") =14
Thankyou[/FONT]<strike>
</strike>[/FONT]