Forum Discussion

Angela McGhin's avatar
Angela McGhin
Brass Contributor
Jun 13, 2018

Using COUNTIF across a range of cells that contain formulae

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

Formulas & Functions
Need Help

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 13, 2018

    Hi Angela,

     

    Is that something like

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

    or I didn't catch?

    • Angela McGhin's avatar
      Angela McGhin
      Brass Contributor
      Jun 14, 2018

      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.

       

      :-) 

Resources