=SUMPRODUCT((INT(A2:A11)=133)*(B2:B11="Unbound"))



"MammaFin" wrote:

HI All,

Thanks in advance for any help that can be provided on the question
below:

I need a function that will produce the total number of of a specific
device in Column A that corresponds with a specific value in column
B.

E.G below column A represents a Hard Disk device of 133GB and Column B
represents if it is being used (Enabled) or not used (Unbound) - I
need to get the total number of 133GB devices that are in the
"Unbound" state.


HDD Status
133.6796875 Enabled
133.6796875 Enabled
133.6796875 Enabled
458.5957031 Enabled
458.5957031 Enabled
133.6796875 Enabled
133.6796875 Unbound
133.6796875 Unbound
133.6796875 Enabled
458.5957031 Unbound

Kind Regards,
Fin