I currently have an excel sheet in which I am working on and want to find the average of Chats and True.
Column A = Type ( which can be either Chat or Offline)
Column S = Chat Response Time (needs to be averaged)
Column V= TRUE or FALSE
I have been using the following formula :
=AVERAGEIFS(CHATLOGS2!S:S,CHATLOGS2!A:A,"Chat",CHATLOGS2!V:V,TRUE)
The formula is working but it is counting the FALSE too when it should not. I know this because I deleted the False columns and the average was correct. Thank you for any help.
Bookmarks