Check out Chip Pearson's Array Formula explanation...
http://www.cpearson.com/excel/array.htm
An array formula is created using Ctrl+Shift+Enter to surround the formula
with braces { }. You can't just type them :O.
Your formula would look something like...
{=SUM(IF($A1:$A1000="widget",1,0)*IF($B1:$B1000="s ale",1,0))}
Make sure you read Chip's site (above) to understand 'WHY' this works.
Otherwise I've given you a meal instead of helped you learn how to fish for
yourself.
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"Jazzman10" wrote:
I want to count the number of times a row has two specific words, in two
different cells eg.
If column A contains the word 'Widget' and column B contains the word 'Sale'
I want to count the number of times this occurs.
I'm sure this is easy but I've spent hours trying to get it to work.