Hi,
Im trying to work out a formula which is to look through three colums of data to sum only the data which matches the specified category.
I have a Primary category of 1, 2, or 3.( Column L) Under these categories, each item has a Secondary Category of 1 through to 20 (Column G). Each of these then has a Sub Category of 1 through to 99 (Column H).
The formula I have at the moment is trying to find how many items have a Primary Cat of 1, with a Secondary Cat of 1 and a Sub Cat of 1. Im only interested in those items with a Primary Cat of 1.(So I will always want to disregard Primary Categories 2 & 3 - but without having to go through all the data)
This is what I have so far:
=SUM(IF($L$2:$L$50="1",IF($G$2:$G$50="1",IF($H$2:$H$50="1",1,1),0)))
At present, all this returns is 0 - not a total of how many items are categorised as 1/1/1.
There is probably a shorter way to get to the question Im asking, but any ideas why its not working?
Im trying to work out a formula which is to look through three colums of data to sum only the data which matches the specified category.
I have a Primary category of 1, 2, or 3.( Column L) Under these categories, each item has a Secondary Category of 1 through to 20 (Column G). Each of these then has a Sub Category of 1 through to 99 (Column H).
The formula I have at the moment is trying to find how many items have a Primary Cat of 1, with a Secondary Cat of 1 and a Sub Cat of 1. Im only interested in those items with a Primary Cat of 1.(So I will always want to disregard Primary Categories 2 & 3 - but without having to go through all the data)
This is what I have so far:
=SUM(IF($L$2:$L$50="1",IF($G$2:$G$50="1",IF($H$2:$H$50="1",1,1),0)))
At present, all this returns is 0 - not a total of how many items are categorised as 1/1/1.
There is probably a shorter way to get to the question Im asking, but any ideas why its not working?