Finding Standard Deviation of a SUMIFS Result

[sethk1024]

I recently posted a question about how to call data from a table with multiple criteria and was told to use SUMIFS

How Would You Go About This?

Table on the left: A history of a given player's stats from 2019 to 2021 (I stripped it down to illustrate the point) Table on the right: stats for a given player in a given year called from the original table. in this example, i'd like to get aaron rodgers' stats in 2021, for total points...

www.mrexcel.com

I did that, and now, I wanted to do some further work on the SUMIFS result, by finding the standard deviation of the data it pulled. and it gives me a #DIV/0 error, even though the resulting output is definitely >0, and error free until attempting to run the stdev of it.

Advice? thanks!

 

[shift-del]

Hi

Your range contains only text values and no number values.

 

[sethk1024]

Hi

Your range contains only text values and no number values.

thanks, however, the range of data it's returning is all numbers. the text data part are just the values for the formula to look up.

for example

its looking up:

Player name: Aaron Rodgers
Year: 2021

to find:

Pass Yards from all games in 2021, Pass Touchdowns from all games in 2021, etc.

I am looking to find the STDEV of one of the returned values mentioned above (pass yards from all games in 2021, etc.)

 

[shift-del]

Check your values with ISNUMBER().

 

[sethk1024]

Check your values with ISNUMBER().

I did. it returns a value of TRUE

 

[shift-del]

Could you share your data with XL2BB?