Forum Discussion
Countif for summary formula
Hello, I'm looking to create a countifs formula and am unsure of how to format it. I am looking to have it count for each employees details sheet and for it to pull the lead converted into hir...
I think this can work, but is only for one tab. You would need to do the formula for the same number of tabs you want to count.
=COUNTIFS('Barry Details'!$B1:$B100,'National Summary'!$B13,'Barry Details'!$D1:$D100,'National Summary'!C$10,'Barry Details'!$C1:$C100,'National Summary'!$B$11) + COUNTIFS (the same for next tab) + COUNTIFS (the same for next tab) ...
And then if I want it to filter out by the word I would put "Foundations"?alannavarro
