I have excel tabel that looks like this:
text1 123
text2 456
text1 789
text2 198
text1 267
text2 453
And I want to calculate average number only of cells containing number that are placed to the right of cell containing text "text1" and I want to do this only in one cell.
If you know how to do this, please tell me.
Regards,
DarkLord76865
Last edited by DarkLord76865; 05-08-2018 at 11:42 AM.
I believe AVERAGEIF is available in Excel 2007:
Formula:
Please Login or Register to view this content.
=AVERAGEIF(A1:A11,"text1",B1:B11)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you on your help guys, this worked perfectly.
If I will have any other questions I'll ask.
Regards,
DarkLord76865
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks