Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
you would use a sum if formula for that
lets say for example your values were in columns A1 - D1
the formula would be
Hi Andrew, I want to set up a formula to add up four columns (that also contain formulas), but in the sum I need it to say that if the cell is a negative number not to include it in the total. Help?
which 4 columns
and do you want to sum everything in the columns or just a single row?
Not sure if this will work:
yes it will
so i give you the correct forumla
No, I meant I was trying to print screen the worksheet to you! Shall I attach it?
if you can attach the sheet
that would make it easier
would it be easier if I just gave you an example formula, and you modify it for your range?
Can only insert image not file?
works on excel too
i know it says image
sorry bout that
don't worry about it
if you are having trouble
just tell me which 4 columns, and I can do the rest
i understand exactly what you need, just need to apply it to the correct columns
Had to save as earlier version of xls.
It is the tab called Babor Prof, Row 6
give me a sec to cehck it out
so you want to sum the range G6 through N6?
but only positive numbers?
No just h6, j6, l6, n6 sum, but only positive numbers
result in column I
column O i mean
give me a couple of minutes to do that for you
can you just show me the formula so i can copy and paste as multiple sheets to do
hold on a sec
=SUM(IF(H6>0,H6,0),IF(J6>0,J6,0),IF(L6>0,L6,0),IF(N6>0,N6,0))PLEASE REMEMBER TO RATE SO I AM REIMBURSED FOR MY TIMEYOU DO SO WITH THE SMILEY FACES UNDERNEATH THIS CHAT
does that make sense to you?
do you need it in the file as well?
well it makes no sense but it works! Thanks very much.