countif conjunctions

[Tom F]

What is the proper syntax for finding the conjunction of two countif functions?

These are the two statements that are desired to be separated by 'and'
countif(e10:e100,"regular")
countif(f10:f100,"basic")

Many thanks for your help,
Tom F

 

[PaddyD]

try:

sumproduct((e10:e100="regular")*(f10:f100="basic"))

see:

http://www.mrexcel.com/wwwboard/messages/8961.html

for how sumproduct() works


edit: although why not just a pivot table?

 

[Tom F]

Thank you PaddyD.

A most clever solution.

Have a Great Day,
Tom F

 

[Mark W.]

{=COUNT(IF(E10:E100="regular",IF(F10:F100="basic",1)))}