ExcelBanter - View Single Post

Don Guillett

Glad to help

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
You know, I was trying to do if with the 'sumproduct' function, but just
got
in a big ball of mess! Thank you! This works wonderfully. You have a
great
day!

Connie Martin

"Don Guillett" wrote:

try
=sumproduct((b2:b5000="Oct")*(v3:v5000=39))
or if col b is properly formatted dates
=sumproduct((month(b2:b5000)=10)*(v3:v5000=39))

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
In a certain cell I need the answered derived from this: If
B3:B5000=OCT,
then count the number of times "39" appears in V3:V5000.

That should be simple enough, but I believe I must think with too much
complexity!

Thank you
Connie Martin