Help with finding the right formula

[iainhmunro]

Afternoon

I would normaly do a good search if I know wjhat I am looking for, but am stuck.

I have two spreadsheets

One that has

Fabrication $ Value Number of entries

On the second sheet. I have a number of entries, like Oil & Gas, Fabrication etc. Each one of them has a $ value associated with it.

On the first sheet, I do have a lookup that does a COUNTIF - it looks for Fabrication in teh second sheet and gives me a number - it works.

What I am trying to do is do the same lookup, but instead of a count, I nee to total the $ values for the Fabrication entries.

Any help would be appreciated.

Iain

 

[Brian from Maui]

Have you tried SUMIF or SUMIFS?

 

[iainhmunro]

Have you tried SUMIF or SUMIFS?

Hi Brian

I had not, but tried - it does not work.

Iain

 

[Brian from Maui]

Can you explain what doesn't work and a sample of your layout and expectecd result.

 

[iainmunro]

Hi Brian

I am expecting to see the total value of each entry in the cell - what I get is 0.

Iain

 

[Brian from Maui]

Hi Brian

I am expecting to see the total value of each entry in the cell - what I get is 0.

Iain

Care to post the formula you're using? If you got the right answer for COUNTIF, SUMIF should work.

 

[iainhmunro]

Care to post the formula you're using? If you got the right answer for COUNTIF, SUMIF should work.

hi Brian

thanks for sticking with this.

here is my code

SUMIF(Info!E2:E86,Details!A3)

 

[Brian from Maui]

hi Brian

thanks for sticking with this.

here is my code

SUMIF(Info!E2:E86,Details!A3)

You forgot the range to sum.

=SUMIF(Info!E2:E86,Details!A3,RangeToSum)