SUMIF & COUNTIF referincing a cell data

[mingandmong]

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]

 

[Fluff]

Remove the quotes from the cell reference, it should be
=COUNTIF(E:E,W1)

 

[mingandmong]

Hi Fluff
this has worked thankyou...""" livfe is simple when you know how

 

[Fluff]

You're welcome & thanks for the feedback