Criteria Met Initiate Formula

[grnaskd]

Hello,

On paper, I think this should work.

I want to make a formula that if special criteria are met, then a separate formula is calculated based on its own special criteria. If the first criteria is not met then nothing happens.

This is what I started with:

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&$U$3:$U$7&"'!H3:H242"),""&A3&"",INDIRECT("'"&$U$3:$U$7&"'!F3:F242"),"*CIV*"))

This allowed me to count civilians across multiple sheets based on if that civilian belonged to a specific company.

Now I need to separate Males from Females. What I would like to do is put a formula before my original that in every instance a MALE appears that belongs to a specific company, the original formula starts. If a FEMALE appears for that same company, the original formula does not start and that person is not counted.

I tried IF but as I understand, it only returns a value and not a function.

 

[RoryA]

I don't know why you have SUMPRODUCT there, but you should just be able to add another criterion to your COUNTIFS to specify either males or females. Which column is that data in?