Hi,

I'm not sure that cross posting between unconnected websites is necessarily
bad, if that is what's going on here. Does everything posted at Mr Excel
automatically post to the Microsoft Newsgroups?

=====
Multi conditional counting can be done with any of the following types of
formulas
1. =SUMPRODUCT((B$1:B$7=F1)*(A$1:A$7=E1))
2. =SUMPRODUCT(--(B$1:B$7=F1),--(A$1:A$7=E1))
3. The array entered equivalents of the above two
4. =COUNT(IF(A$1:A$7&B$1:B$7=E1&F1,)) (array entered)
5. =COUNTIFS(B$1:B$7,F1,A$1:A$7,E1) (in 2007)

in each case B1:B7 and A1:A7 are the ranges you are checking for the
conditions in E1 and F1.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"NBVC" wrote:


Please show Domenic some respect, he has been helping you extensively in
your post he 'Complex Formula need help with - Page 2 - MrExcel
Message Board'
(http://www.mrexcel.com/forum/showthr...=397801&page=2)
under a different ID.

Please continue there only... I also noted that you now understood
cross-posting rules per you comments he 'Sports Tipping Formula -
Excel Help Forum' (http://tinyurl.com/nna6lj)


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=110054