Calculating Cell Values Using an If Statement

**TWP** · 11-03-2015, 01:33 PM

Hi Forum,

I am asking beginner stuff here and I know I've done this many times before but for some reason, this will not work for me this time.
I'm trying to get an IF statement to work on my "Summary" page.

I'm calculating things on Sheet 1 and need a summary calculating as I go.

I thought I was doing it right.

I've highlighted the cell in red that I need the formula in.

Any help is GREATLY appreciated!!

**Ace_XL** · 11-03-2015, 01:37 PM

Use

=INDEX(Sheet1!F:F,MATCH(A3,Sheet1!A:A,0))

and get rid of merged cells in Sheet1, they are the work of the devil!

**TWP** · 11-03-2015, 02:19 PM

Thanks, that worked great; however, I will be putting Temporary Telephone many times throughout my sheet and will need to have the values of it continuously added up. This formula is only seeking it the one time, I want it to search all of the first sheet for the words Temp Telephone and add all in the summary page. How do I do that? Get it to add the more I put on Sheet 1?

**TWP** · 11-03-2015, 02:46 PM

Anyone?

Help....

Should I use Lookup or VLookup?

**TWP** · 11-03-2015, 02:59 PM

I tried LOOKUP with no luck ... *sigh* ..
See attachment

**Ace_XL** · 11-04-2015, 01:38 AM

In C3

=SUMIF(Sheet1!A:A,A3,Sheet1!C:C)

Copy down

Calculating Cell Values Using an If Statement

LinkBack

Thread Tools

Rate This Thread

Display

Calculating Cell Values Using an If Statement

Re: If statement

Re: If statement

Re: Calculating Cell Values Using an If Statement

Re: Calculating Cell Values Using an If Statement

Re: Calculating Cell Values Using an If Statement

Thread Information

Users Browsing this Thread

Similar Threads

nested IF statement or AND? trying to write an IF statement with multiple conditions

[SOLVED] If statement to select data - nested statement - assistance

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions