I am currently having an issue in counting data in one column and then for it to count the sum of a word of another colum
eg.
A B
Accomodation New
Accomodation New
Accomodation Current
Travel New
Travel Current
Car New
Car New
What i want the formula to do is to count column A for Accomodation and then throught set criteria for it to tell me how many are new, I want to pull this data into another sheet to create a graph, so I will be able to create the graph the data tell me I have 12 Accomodations and 6 are New and 6 are current..
I have been trying this formula:
=SUMPRODUCT(--('Contract Master File v1'!B11:B88="accomodation"),--('Contract Master File v1'!L11:L88="new"))
I already have a countif formula to give me the totals of a just cant seem to get the detail??
Bookmarks