Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
Hi,
I have a spreadsheet with multiple sheets with multiple data. Until now it has worked really well but i have been asked to provide further MI on the data i already have.
Let's say the layout is as below :_
A B C D E
FOOTBALL SIMON BOY 15 ?????
CRICKET STEVE BOY 13
TENNIS GAIL GIRL 8
RUGBY RUBY GIRL 23
GOLF STEVE BOY 13
Now in E1 i am wanting to find out the combined age of the first criteria (Steve) from column B and the second criteria (Boy) from column C. The result in E1 should be 26.
I'm not sure on the best way to proceed or even the correct function. I also have filters in place so when E1 gets populated it needs to count only visible cells (this isn't shown on the above but on my spreadsheet i have around 20,000 rows of data). My spreadsheet currently shows #N/A when the filters are in place.
Hope this makes sense and i can provide more information if required.
Thanks
I have a spreadsheet with multiple sheets with multiple data. Until now it has worked really well but i have been asked to provide further MI on the data i already have.
Let's say the layout is as below :_
A B C D E
FOOTBALL SIMON BOY 15 ?????
CRICKET STEVE BOY 13
TENNIS GAIL GIRL 8
RUGBY RUBY GIRL 23
GOLF STEVE BOY 13
Now in E1 i am wanting to find out the combined age of the first criteria (Steve) from column B and the second criteria (Boy) from column C. The result in E1 should be 26.
I'm not sure on the best way to proceed or even the correct function. I also have filters in place so when E1 gets populated it needs to count only visible cells (this isn't shown on the above but on my spreadsheet i have around 20,000 rows of data). My spreadsheet currently shows #N/A when the filters are in place.
Hope this makes sense and i can provide more information if required.
Thanks