CountIfs????

[frankiejr101]

Using Excel 2007. How would I use a formula to say "If you see a letter e in B5:M7, AND there is a number 1 in B8:M8, add up the 1's that fit these criteria? Thanks!



-- removed inline image ---

 

[Oeldere]

Try this one

=somproduct((B5:M7="e")*(B8:M8=1))

 

[Scott Huish]

I think this is what you are after:

=SUMPRODUCT((B8:M8=1)*(B5:M7="e"))

 

[frankiejr101]

Thanks guys, completely forgot about SUMPRODUCT!