Dear Experts
please download my example sheet to see the problem.
thanks
Dear Experts
please download my example sheet to see the problem.
thanks
Abdul Rouf Roofi
F 1 FB 2 MR 3 ES
In D10 Cell
=SUMPRODUCT(1*COUNTIF(INDIRECT("'"&F1:F3&"'!N:N"),20))
In D11 Cell
=SUMPRODUCT(1*COUNTIF(INDIRECT("'"&F1:F3&"'!N:N"),50))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Copy and Paste this formula in cell D10,
=SUM(COUNTIF(FB!N1:N15,"=20"),COUNTIF(MR!N1:N15,"=20"),COUNTIF(ES!N1:N15,"=20"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks