Excel Conditional Formula

[tps131]

I have a large excel spreadsheet where I want the average number of days an issue was opened to be calculated based upon the type of issue. I have a formula that calculates the count of the types accurately in one column, now I need to have a count on another column based upon the value in the first column.

 

[AnotherHiggins]

Have a look at the SUMIF function.

To figure the average, you can combine that with the results of a Countif function.

[tab][COLOR=blue white]=SumIf(A1:A1000, "Thing1", B1:B1000) / CountIf(A1:A1000,"Thing1")[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[tps131]

That worked, Thanks alot

 

[AnotherHiggins]

Glad to help!


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[tps131]

Another issue has also surfaced. What would be the easiest way in an excel formula to combine two criteria. Example, now within the overall group(1st criteria "C") want to cut that down by (5)days(2nd criteria "G")...This is what I think it would look like but it isnt working. Any suggestions??
=Sum(Countif(C:C, "Group Modify") & (G:G, "<5"))