Formula Problem

C

Cissy

Hello,

I have a workbook with two sheets, one detailed, one summary. I'm trying to
sum the numbers entered in K2:Z11 everytime "16" is entered in A2:A11. This
formula keeps returning 16. On the summary sheet 2, I entered the formula
=IF(Sheet1!A2:A11,"16",SUM(Sheet1!K2:Z11)).

Thank you in advance for any help.
 
P

Pete_UK

Have a look at the SUMIF function in Excel Help - you are nearly
there.

Hope this helps.

Pete
 
C

Cissy

I tried the SUMIF function, but get 1 as the answer, even though several
numbers are entered in the range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF conditional to copy column from one spreadsheet to another 3
variable column 1
Need blank cells to remain empty 7
Vlookup and return sheet name also 2
Build a reference to another worksheet from cell values in currentsheet 3
Help with Sumif and INDIRECT 9
HELP!! How to formula the "sheet" link 2
data validation with a formula 7

Top