Using COUNTIF across a range of cells that contain formulae

[Angela McGhin]

I'd like to use a simple COUNTIF function on a range of cells - the cells show either an 'M' (male) or 'F' (female).

However the values for those cells actually come from another tab in the worksheet so the cells I'm counting contain a formula to pick up that value, so the COUNTIF function isn't picking anything up.

Is there a way round this?

Thank you

[#2]

Hi Angela,

Is that something like

=COUNTIF(AnotherSheet!A1:A10,"M")

or I didn't catch?

[#3]

Hi Sergei

Thanks for the reply - I've just checked my spreadsheet and can actually get it working! I must have had an error in my previous formula.

:)