Thanks for feeding back - see here for further details on the use of
SUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Hope this helps.
Pete
On Nov 19, 11:18 am, Mifty wrote:
Thank you to Stephen, Pete and Mike.
Sumproduct seems quite a useful function
Cheers
--
Mifty
"Mifty" wrote:
Hi Everyone,
I would like to be able to count the number of females with a score in C.
so using Countif how do I say countif B = F and C equals a number?
I'd be grateful for any ideas how to do this.
Could I use Sumproduct as an alternative to countif?
Thanking you in advance
--
Mifty- Hide quoted text -
- Show quoted text -