Thread
:
countif using multiple criteria
View Single Post
#
3
Posted to microsoft.public.excel.programming
Marcusdmc
external usenet poster
Posts: 26
countif using multiple criteria
Thank you! I didn't realize you have to declare your array more
detailed besides saying A:A or B:B... works great :)
{=SUM(IF(wks2!$A$1:$A$12000=B5,IF(wks2!$F$1:$F$120 00=$D$33,1,0),0))}
-Marcus
Reply With Quote
Marcusdmc
View Public Profile
Find all posts by Marcusdmc