Two work sheets cell comparison..

mathewmunna - Dec 10, 2014 at 12:15 AM
mathew munna - Dec 15, 2014 at 12:57 AM

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

I hope someone can help me with this...I've done this before but can't remember how.

I have a list of names (for an attendees list) and I need to show an extended total for each
person and the number of guests they will bring. Here's the layout...

B2 is the person's name
C2 is the number of guests they will bring
D2 is the total for that person (including them)

I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.

Hope that makes sense. Thank you in advance for helping.

Hello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down box, I would like the adjacent cell to poulate with the number (eg Minor injury = 4) I have to do it for the three blank columns  Any help will be much appreciated. Thanks, Mitch.

Hello,

I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) but I keep getting #name errors.

If its any help, the cell with the date (I12) is retreiving it via a vlookup function and is not just a date entered manually.

The only other value in I12 will be an #n/a error. Is it possible to use ISNA to return no if true and yes if false?

Could anyone help?

Hi all, counting cell containing only numbers

Is there a formula to count only cells containing any numbers in general? Moreover, is there a formula to count values containing an specific number of digits?

Much appreciated