I am trying to avoid using vlookup... That might be the most over used statement in Excel world.
I have a sheet where I need the result if two criteria are met.
For simplicity I'll try to explain below
A B C
NAME Date Total
So if you have on sheet 1 "Name" and it falls within "Date" it provides "total"
Any help would be appreciated... This might be one of those .... DUH formula's but - my brain is broken.
I have a sheet where I need the result if two criteria are met.
For simplicity I'll try to explain below
A B C
NAME Date Total
So if you have on sheet 1 "Name" and it falls within "Date" it provides "total"
Any help would be appreciated... This might be one of those .... DUH formula's but - my brain is broken.