I need some help. I'm try to cross analyse the national Covid-19 data base.
I'm reasonably familiar with the SUMIF function with a single conditional like
SUMIF(A:A, D3, H:H)
I use it for the bulk of my analysis.
I can't figure out the syntax to put a double conditional inside a SUMIF.
So here is the example I'm struggling with.
As a hypothetical example, say my spread sheet looks like this:
Column A has the date for the data in that row.
Column B has the two letter code for the state (e.g., NY) that the row contains.
I have the date of interest (e.g., 20200403) stored in cell D1.
I have the date of interest (e.g., NY) stored in cell E1.
The data sets contains many dates and many states, but for each state and date combination, there is only one row.
So, say I want to return the data in Column H, that is for the date in D1 and the state in E1.
I'm guessing that if I were better at EXCEL, I could find it with a LOOKUP function, but frankly every time I try I screw up.
Since the date/state combination are unique, then I could find the data for the following function which I can write in prose, but can't find the correct syntax for in a SUMIF; if it's possible.
That prose statement is:
SUM the data in Column H if the cell in Column A equals the cell D1 AND the cell in Row B equals the cell E1.
Since the date/state combinations are unique, that function should yield just the one result in Column H that I am looking for.
Can anyone help?
metsci
Bookmarks