CountIf formula help
I have a document with 2 worksheets. I need to count how many times item
12W45 occurs and how many times this item has a value of <=3 in another column. Here is the formula that I am using, or trying to use: =COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606)) Something is wrong because it is giving me a value of 1, when it should be 7. Can anyone tell what I am doing wrong? |
hit F2 to edit your formula, then hit Cntrl+Shift+Enter.
if that fails try =SUMPRODUCT((detail!H4:H32606="12W45")*(detail!L4: L32606<=3)) and just hit enter after keying it in. "Lucien" wrote: I have a document with 2 worksheets. I need to count how many times item 12W45 occurs and how many times this item has a value of <=3 in another column. Here is the formula that I am using, or trying to use: =COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606)) Something is wrong because it is giving me a value of 1, when it should be 7. Can anyone tell what I am doing wrong? |
Well, the SUMPRODUCT formula worked perfect.
Thanks for the quick answer! "JMB" wrote: hit F2 to edit your formula, then hit Cntrl+Shift+Enter. if that fails try =SUMPRODUCT((detail!H4:H32606="12W45")*(detail!L4: L32606<=3)) and just hit enter after keying it in. "Lucien" wrote: I have a document with 2 worksheets. I need to count how many times item 12W45 occurs and how many times this item has a value of <=3 in another column. Here is the formula that I am using, or trying to use: =COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606)) Something is wrong because it is giving me a value of 1, when it should be 7. Can anyone tell what I am doing wrong? |
All times are GMT +1. The time now is 04:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com