Dear all,

This is driving me crazy, i just want that my formula says e.g. "Underweight" when the value in O2 is below 18.5, "Normal" if the value is between 18.5 and 24.9:

]]>This is driving me crazy, i just want that my formula says e.g. "Underweight" when the value in O2 is below 18.5, "Normal" if the value is between 18.5 and 24.9:

Underweight = <18.5 |

Normal weight = 18.5–24.9 |

Overweight = 25–29.9 |

Obesity = BMI of 30 or greater Why is this not working :( :( : =IF(O2<18.5,"Underweight",IF(18.5<=O2<=24.9,"Normal",IF(25<=O2<=29.9,"Overweight",IF(O2>30,"Obesity")))) Thank you so much for any suggestions!! |

I am keeping Phenology records using an excel spreadsheet.

I have columns for successive northern hemisphere winters, 12018/2019, 2019/2020, 2020/21 etc Each cell is formatted as Custom Date: Type DD/MMM

I have two rows for each of 70+ species and columns for each year with the end column for calculating the average date of an event and the average difference in days

My formulae uses an array in the formula field {=AVERAGE(DATE(,MONTH(F14:I14),DAY(F14:I14)))} But this produces some strange results, for example 2nd May, for an average between 23rd December and 8th January

Because this is about the first time an effect is noticed, in any spring period, it can be between late November in one year and late January in the following year, so crossing the year boundary. I suspect that the average is looking within years rather than between year

Any suggestions for how I can correct this formulae would be much appreciated.

Spring watch Croatia average calc.xlsx

Thanks for reading

I have columns for successive northern hemisphere winters, 12018/2019, 2019/2020, 2020/21 etc Each cell is formatted as Custom Date: Type DD/MMM

I have two rows for each of 70+ species and columns for each year with the end column for calculating the average date of an event and the average difference in days

My formulae uses an array in the formula field {=AVERAGE(DATE(,MONTH(F14:I14),DAY(F14:I14)))} But this produces some strange results, for example 2nd May, for an average between 23rd December and 8th January

Because this is about the first time an effect is noticed, in any spring period, it can be between late November in one year and late January in the following year, so crossing the year boundary. I suspect that the average is looking within years rather than between year

Any suggestions for how I can correct this formulae would be much appreciated.

Spring watch Croatia average calc.xlsx

Thanks for reading

When I try to drag this formula down the column the formula does not populate correctly.

=IF(AB4="","",IF(COUNTIF(O$4:Y$4,AB4)=0,"L","W"))

What happens is the O$4;Y$4 stays the same all the way down. What I need it do to is to change to O$5;Y$5, O$6;Y$6, O$7;Y$7,etc.

I have never seen this before so I am kinda confused on what is going on here. Thanks for your help.

]]>=IF(AB4="","",IF(COUNTIF(O$4:Y$4,AB4)=0,"L","W"))

What happens is the O$4;Y$4 stays the same all the way down. What I need it do to is to change to O$5;Y$5, O$6;Y$6, O$7;Y$7,etc.

I have never seen this before so I am kinda confused on what is going on here. Thanks for your help.

hi all,

I have a sheet which contains data sets (3 rows per data set), see Product Level sheet of attachment. I want to consolidate and total the numbers into the total sheet.

Example; Material ID A and Material ID C are paired in Product Level sheet. I want a way of addProduction stocks total.xlsxing together their attributes (column J) of Product Level sheet and include in the Total sheet.

I have manually input a calculation in the total sheet so you can better understand.

Please not the order of the paired data sets in the Product Level sheet will be random (so I will need formulas that update in the Total sheet automatically, whenever there is a change in the Product Level sheet).

Hope this makes sense and thanks in advance for the help

I have a sheet which contains data sets (3 rows per data set), see Product Level sheet of attachment. I want to consolidate and total the numbers into the total sheet.

Example; Material ID A and Material ID C are paired in Product Level sheet. I want a way of addProduction stocks total.xlsxing together their attributes (column J) of Product Level sheet and include in the Total sheet.

I have manually input a calculation in the total sheet so you can better understand.

Please not the order of the paired data sets in the Product Level sheet will be random (so I will need formulas that update in the Total sheet automatically, whenever there is a change in the Product Level sheet).

Hope this makes sense and thanks in advance for the help

I am trying to count two separate pieces of data which appear in the same excel column. The columns will have a date followed by a quantity so look something like this : 24/11/20 (30). I'm trying to count the two pieces of data separately and wondered if that's possible using formulas or do I need to separate the data into two separate columns? Help is greatly appreciated! TIA.

]]>Hi there! I have a master question bank and I want to create auto populated work sheets based on contents of columns in the master sheet. So as an example, this is the master question bank:

Consider it starts at column A and ends at G. I'm going to have a worksheet for each animal column (so worksheets called Dogs, Cats and Rodents). Each worksheet should be populated based on the x in the dogs, cats or rodents columns. But the trick is, I only want the cell contents of columns A, B and D in the worksheets. So the Dogs worksheet would look like this:

Do I need to run a macro, or can it be a VLOOKUP. Some of the worksheets will have more rows than others so I'd need it set up so it doesn't have error messages or zeroes etc. I'm not sure how to make this happen. Any help is greatly appreciated. :)

Thanks in advance.

]]>Question | Reference | Revision | Color | Dogs | Cats | Rodents |

Question 1 | Manual reference is 1 | 1 | Red | x | ||

Question 2 | Manual reference is 2 | 2 | Blue | x | x | |

Question 3 | Manual reference is 3 | 3 | Green | x | ||

Question 4 | Manual reference is 4 | 4 | Pink | x | ||

Question 5 | Manual reference is 5 | 5 | Yellow | x | ||

Question 6 | Manual reference is 6 | 6 | Purple | x | ||

Question 7 | Manual reference is 7 | 7 | Orange | x | x | |

Question 8 | Manual reference is 8 | 8 | Black | x | ||

Question 9 | Manual reference is 9 | 9 | White | x |

Consider it starts at column A and ends at G. I'm going to have a worksheet for each animal column (so worksheets called Dogs, Cats and Rodents). Each worksheet should be populated based on the x in the dogs, cats or rodents columns. But the trick is, I only want the cell contents of columns A, B and D in the worksheets. So the Dogs worksheet would look like this:

Question | Reference | Color |

Question 2 | Manual reference is 2 | Blue |

Question 6 | Manual reference is 6 | Purple |

Question 7 | Manual reference is 7 | Orange |

Do I need to run a macro, or can it be a VLOOKUP. Some of the worksheets will have more rows than others so I'd need it set up so it doesn't have error messages or zeroes etc. I'm not sure how to make this happen. Any help is greatly appreciated. :)

Thanks in advance.

I have a wages spreadsheet (sample attached) which has columns for Employee ID, quarter in which wages were earned and wages earned

I have a summary table below the date intoi which I wish to sum the total wages for a selected employee in a particular quarter.

My underrstanding of thye problem is that I wouyld need to index the wages , match the employee id in the sumary table AND the quarter in the summary table to total the employee's wages in each quarter.

I am using ther formula

I have a summary table below the date intoi which I wish to sum the total wages for a selected employee in a particular quarter.

My underrstanding of thye problem is that I wouyld need to index the wages , match the employee id in the sumary table AND the quarter in the summary table to total the employee's wages in each quarter.

I am using ther formula

=IF(ISBLANK($A27),0,IFERROR(INDEX($C$4:$C$16,MATCH($A27,$A$4:$A$16,0)),"")) but that not only does NOT correctly sum each employee for Quarter 1 but fails to sum Q2,3,and 4. The atached sample shows the Employee ID (column A), Earniong Quarter (Column B) and wages (Column C). Below that data is an incorrect summary table and a table showing my expected values. Any help is solving this? Thanks. |

I have attached a copy of the spreadsheet I would like help with

There is data in cells A,2 to E,14

My aim is have formulas in cells H,5 to AE,9

H5 I would like a formula so if cells in column B from rows 2 - 100 = 11 then H,5 will total all cells in column D rows 2 - 100 multiplied by the corresponding row in column C

ie(h5= if (B2=11, then C2*D2)+if(B3=11, then C3*D3)+if(B4=11, thenc4*d4)+if(b5=11, then c5*d5) etc through to B100

Any help would be very appreciated

sample 1.xlsx

There is data in cells A,2 to E,14

My aim is have formulas in cells H,5 to AE,9

H5 I would like a formula so if cells in column B from rows 2 - 100 = 11 then H,5 will total all cells in column D rows 2 - 100 multiplied by the corresponding row in column C

ie(h5= if (B2=11, then C2*D2)+if(B3=11, then C3*D3)+if(B4=11, thenc4*d4)+if(b5=11, then c5*d5) etc through to B100

Any help would be very appreciated

sample 1.xlsx

Sir,

i require formula for Sum of total Paid Fees , which will be Total of Installment 1 & Instalment 2 with course wise and month wise from student data and total will be in fees summary sheet.

i require formula for Sum of total Paid Fees , which will be Total of Installment 1 & Instalment 2 with course wise and month wise from student data and total will be in fees summary sheet.