Excel formula request

S

sparkpz

Joined
Jun 4, 2012
Messages
1
Reaction score
0
hi, im new to excel and i need help if possible
i have 3 sheets: sheet1, sheet2, sheet3
i want from sheet1 to sum B3:b4
then to substract the result form sheet2 b3:b4
and the result to be displayd in sheet3
i tried =SUM(sheet1!B3:B4)&""&=sheet1!B3-sheet2!B4
and it doesnt work


cant seem to combine them together:(
 

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

EXCEL - IF(IFERROR(VLOOKUP question 0
How do i transfer cell data from one sheet to the other in Excel 4
import datas from one excel to another 1
How to reach at the source of the formula 5
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Count matching data 5
Need help to filter data from multipule sheets to specific sheet 2

Top