counting values from two different columns for epidemiology thesis

[maccer123]

Hello guys, I can't figure out how to count multiple values from two different columns and I really don't use excel too often but my thesis is forcing me to, so it is a must to figure this out.

All I want to know is the occurrences of diseases to a particular year. I have an excel file that has a messy record of diseases from our local hospital and it's my job to organize it by year (as my adviser wants me to) and the point of this is that so I can make some sort of graph for the defense of my thesis. Like for example, how many people got diagnosed with DENGUE in the year 2004 and the value DENGUE and the value 2004 are in separate columns. Does anyone know how to make a formula for this? I really am only familiar with the basics; I don't know how to make functions D:

 

[ghrain22]

ok then try this:
Countifs($H$1:$H$10,"=2004",$I$1:$I$10,"=*Dengue*")

I suppose we could've used a similar concept on the date aswell. But that will count it if the cell contains the word Dengue (as opposed to if the cells value is equal to Dengue)

 

[maccer123]

oh thank god THAT WORKED! thank you very much

 

[ghrain22]

Nice. If you're going into charting I'd suggest checking out pivot Charts. But It'd be helpful if you could pull the disease out of the the phrases.

Glad Everything worked out. Sorry about all the hassle