Countifs [SOLVED]

[dawa]

https://www.dropbox.com/s/f2pr4zq0ae9ktn9/Countifs.xlsx


help on countifs......extract from multiple sheet...

 

[Smallman]

Hi Dawa


Using Atom on the Extract sheet as an example isn't it just adding the two together. Eg Cell D4 on the Extract tab;


=COUNTIFS(aa!$D$2:$D$9,$B4,aa!$E$2:$E$9,D$2)+COUNTIFS(ab!$D$2:$D$9,$B4,ab!$E$2:$E$9,D$2)


If not a table with the desired result would be really helpful.


Take care


Smallman

 

[dawa]

Thanks...i have tried it but may be there was some problem with my sheet but i figure it out and made sure from your tip. Thanks ..


Marked it as SOlVED

 

[Smallman]

No worries Dawa


See you next time.


Smallman