LinkBack URL
About LinkBacks
averageif problem.xlsxHello everyone, I am having quite a big problem, I trying to make composite market prices, but I'm having problems with it, here is the spreadsheet, the formula is at the VH column, anyone has any ideas on how to fix it?
Can't make AverageIF ignore empty cells
averageif problem.xlsxHello everyone, I am having quite a big problem, I trying to make composite market prices, but I'm having problems with it, here is the spreadsheet, the formula is at the VH column, anyone has any ideas on how to fix it?
AverageIf doesn't work on non -contiguous ranges, so maybe this instead:
Formula:
Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
both of these return 3.48552381 as the result
While this:
Formula:Please Login or Register to view this content.
returns 7.3196
not sure which is correct for your problem, so I offered both
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
The second one seems to be the correct one, by the way, is using the formula for the other rows/columns gonna make it work the same? As I can see, I should change the phrase "Average Price" to the other cell phrases, to make it do the needed calculations or am I wrong?
p.s. thank you!
no you are correct, but to make it easier, you could do it this way:
Formula:Please Login or Register to view this content.
then it will use the column header of the column you are in for the criteria
Then just drag down and across
Hope this helps
EDIT-
1 more change, as I only took it to the last Average Price column, you need to adjust the following as well:
Formula:Please Login or Register to view this content.
Last edited by dredwolf; 11-15-2013 at 11:52 PM.
I tried simply entering another phrase also worked, thank you, saved me lots of time! +rep for you!
Thank You !
(Also check Post 4 edit..you may be missing a few values if you don't change accordingly )
And you are very welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks