Hi All,
I have 5 different values in five variables, in that some values are negative, so i want to take average only for positive values..
plz help me
thanks
Deepak
Hi All,
I have 5 different values in five variables, in that some values are negative, so i want to take average only for positive values..
plz help me
thanks
Deepak
Give a try to AVERAGEIFS function.
Last edited by Fotis1991; 09-16-2015 at 06:33 AM.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks to reply Fotis
I was trying to use average if, but I unable to get how to use it with variables.
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks