Re: Formula to work out percentage using multiple criteria
its the sum of all the winter gloves in column d / the sum of all the winter gloves in e
Re: Formula to work out percentage using multiple criteria
its the sum of all the winter gloves in column d / the sum of all the winter gloves in e
I have attached an example of what I am trying to do.
I need formula to populate cell F15, F16, F17
Re: Multi-conditional Table Formula 11th Feb Thread
I have added another table to the attachment
I posted a thread in feb and had a response however I still cant get it to work.
I have attached the incorrect results i am getting
Re: If Cell A Matches And Cell B Is Less Than 89 Then Yes
Seems to be correct, but when I drag the formula into the other cells it breaks.
Only seems to work when I go through each cell individually and make them an array
Sorry No idea how to write a question regarding the forumla i need!!
I'm trying to add "yes" as per the attached spreadsheet, using forumla.
Account codes are duplicated (sometimes more than once, although no shown on the example) each account code needs to have the same yes column.
Hope this makes sense!
Re: Conditional Summation Based On Drop-Down Choice
Can't get this to work, and I don't think its quite what I'm looking for
Can this be done on VB? Referencing to the data value ie "fruit" / "vegetable" rather than cell dependant.
I have attached a spreadsheet that I need to automate
Cell C3 is a drop down box of the raw data found on the raw data sheet.
I would like B6-8, c6-8 and d6-8 to automatically updated and change depending on what users select from the drop box in C3.
(so basically im trying to re create the yellow table with formulae/vb.)
any ideas?
I need to remove the last 2 digits from a cell that maybe different lengths. For example:
PL26 7QS
ST20 0AW
LE4 8LF
PE30 3WH
CF31 3AY
I would like a formula to return the top 10 products sorted by value, but to return the colour name in order starting with the larges and the value in a different column. Ideally I would like to do as little formating as possible, if it could be done in one formula that would be great.
I have attached a spreadsheet as an example
Re: Combine/Merge Duplicate Cells & Sum Corresponding Values
The fruit type and quantity are in different columns. When I use a pivot table the duplicates still appear and the values are aren't added together.
For example I have a spreadsheet with 900 different pieces of fruit, some of the fruit is duplicated. I would like the spreadsheet to contain 1 row for every piece of fruit. The number of fruit listed in the additional column should be added together.
Orange 2
Orange 3
Orange 4
Apple 10
Apple 11
Would become just one line per fruit and the values would be added together
Orange 9
Apple 21
I need to copy a number of excel pages that contain text, data (with formulae) charts, and pictures onto powerpoint. This is because the pages need to be view on a slide show.
Also the excel pages will be updated regularly so need to update the powerpoint presentation as well if possible.
Thanks
Gemma
Re: Prevent #DIV/0 In Conditional Average
Hi
the formula seems to blank the cell if i replace the 1 and 0 with "" as below, however its blanking the cells that have data to average.
=IF( SUM(IF('By All Students'!$S$3:$S$100>=80,IF( 'By All Students'!$S$3:$S$100<92, IF('By All Students'!$Q$3:$Q$100="11.2/AR1","")))),AVERAGE(IF('By All Students'!$S$3:$S$100>=80,IF( 'By All Students'!$S$3:$S$100<92, IF('By All Students'!$Q$3:$Q$100="11.2/AR1",'By All Students'!$O$3:$O$100)))),"")[hr]*[/hr] Auto Merged Post;[dl]*[/dl]How does DAVERAGE work?[hr]*[/hr] Auto Merged Post;[dl]*[/dl]How does DAVERAGE work?
I have an average array formula that works fine when it has something to average. However I get the #Div0 error when there is nothing the average. I need to replace the error message in the cell to be blank. Until there is data to be averaged. I have tried to use ISERROR but struggling to get it to work with my multiple criteria.
This is the formula i am trying to amend:
=AVERAGE(IF('By All Students'!$S$3:$S$100>=80, 'By All Students'!$S$3:$S$100<92, IF('By All Students'!$Q$3:$Q$100="11.1/AR",'By All Students'!$O$3:$O$100)))
Can anyone help?