using the countif function

Microsoft Excel 2003 (full product)
September 28, 2010 at 14:59:13
Specs: Windows XP, 512 MB RAM

I have an excel sheet where I am supposed to count for a particular word. After the count is done on that particular column, I am supposed to count another column where there is a number, say 40. Therefore the output should be a number, lets say 6.

Basically, it also means that the first output gives me 92 and the 92 rows containing the number 40 is 6, I therefore need to publish 6 as the final output.

See More: using the countif function

Report •

September 28, 2010 at 21:09:47
Thanks for letting us know what you need.

If you want some help with that, feel free to ask.

Report •

September 29, 2010 at 13:43:07
Hi, Am wondering if you can provide me a solution to the above mentioned details.


Report •

September 29, 2010 at 16:21:06
Try this, adjust the range as required.



1 - SUMPRODUCT doesn't like to use an entire column. The largest range you can use in Excel 2003 is 65535 rows.

2 - The ranges for each array must be equal or SUMPRODUCT will return #N/A.

Report •

Related Solutions

Ask Question