Hi, 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.

Thanks for letting us know what you need. If you want some help with that, feel free to ask.

Hi, Am wondering if you can provide me a solution to the above mentioned details. Sincerely,

Try this, adjust the range as required. =SUMPRODUCT((F1:F500="Word")*(G1:G500=40))

Tips:

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.

Ask Your Question

Weekly Poll