Hi Alex
here's two methods
=SUMPRODUCT(--(D3:D353),--(D3:D35<7))
=COUNTIF(D3:D35,""&3)-COUNTIF(D3:D35,""&6)
Cheers
JulieD
"Alex" wrote in message
...
I need to count how many cells in column D have a value in them between 7
and
3.
I cant find anything that lets me use between as criteria and Countif only
allows me to have 1 criteria.
Any ideas?
|