Criteria, Help please -LAPTOP WORKSTATIONS

Good morning fine people!
I have this sheet - list thousands assets. Laptops copiers faxes workstations printers in column E. Column G list Hard drives for the LAPTOPS AND WORKSTATIONS.
Col I list the status.

Now - I need to use the Countif formula to caluate the BLANKS found in Col G (Hard drives) HOWEVER,I need to be careful - for i need to eliminate within the status col Disposed of (i dont want that counted) and i dont want to count the copiers and faxes printers,

I know my number is 82. However, because the formula is counting printers - faxes and disposed of it is coming up with a 1264 number. which is way off.

how do i elmininate these ..

i tried with =countif(gxxx:gxxx,"")-countif(ixxx:ixxx,"diposed of") - but that is as far as i was able to get - 1264. I dont know how to take out those copiers and faxes and such.

Any help from Excel experts?

I will be forever grateful

Sincerely
HollyNoel

Thank you for replying so quickly.
Okay
Attached is a "dummy" sample

You will see in column a "class"
a list
Workstation, Copier, Laptop, Fax, Printer, Other Printer, Multi-Function Device, Workstation

Col B is the serial number
C is hard drive D is the status of these assets

I need to count only the blanks of column C that pertain to Workstations and Laptops ONLY - and not include Disposed Of status in the process

So i have 2 hurdles.
Take out the
1) Copier,Fax, Printer, Other Printer, Multi-Function Device
2) Disposed Of
in the formula

Make sense?

HollyNoelsample1.xlsx

Hey there Ford,
Thank you for the quick response again, so helpful.

It seems to still count the other assets (fax, copiers, etc)
Is there a ignore hidden formula?

Shg, That didnt help either.
It didnt even take at all actually.
I need this to count w/o having to filter... for this is being distributed company wide. the numbers need to be inputted and seen as is with out any adjustments made.

I am a "beginner" to Excel which i understand can be trying to experts i am sure when lending a hand so i thank you for your help and apologize in advance for my ignorance.

Hollynoel

ah.. OK.. Problem though.. when i enter your formula into my sheet i am working on.. it doesnt budge. nothing happens.
it works on the sample just fine.
when i work w my actual sheet of 5923.... nothing.

yay!! WORKED!

I re-entered the formula - and it worked. MATCHED my number... super stoked! Thank you!

Thank you!

I moved the status column to the end of my report .. and made it work that way.,
awesome.
Love this learning stuff.

have a great day to both of you that helped!

Ha! It's okay!

Thank you!! "

Have a great evening...