Hi. First, THANKS for offering this resource!
Now, my question...
I'm trying to count the number of instances that two criteria in a given row are met. Seems like it should be simple enough, but I haven't been able to get the formula right.
Here's an example...
column A........... column B
DESKTOP........... STORAGE
DESKTOP........... STORAGE
LAPTOP............. STORAGE
DESKTOP........... STORAGE
LAPTOP............. DEPLOYED
LAPTOP............. DEPLOYED
DESKTOP........... STORAGE
I want to show that...
# desktops deployed = 0
# desktops in storage = 4
# laptops deployed = 2
# laptops in storage = 1
What is the formula to do this?
THANKS!
Now, my question...
I'm trying to count the number of instances that two criteria in a given row are met. Seems like it should be simple enough, but I haven't been able to get the formula right.
Here's an example...
column A........... column B
DESKTOP........... STORAGE
DESKTOP........... STORAGE
LAPTOP............. STORAGE
DESKTOP........... STORAGE
LAPTOP............. DEPLOYED
LAPTOP............. DEPLOYED
DESKTOP........... STORAGE
I want to show that...
# desktops deployed = 0
# desktops in storage = 4
# laptops deployed = 2
# laptops in storage = 1
What is the formula to do this?
THANKS!