This one is probably easy to do.
Basicly i have row of numbers. I want the numbers to give me a sum total if a cell that is not in the row contains an "x"
Row of number from A1:A5 each cell has the number 1 in the cell
if there is a x in cell A2 i would like to get the sum of the numbers in A1:A5 in cell A3.
was trying =SUMIF(A2,"x",A1:E1) this is the formula in cell A3
I am expecting the result of 5, this formula returns the value of 1 since there is only 1 x in cell A2.
Thoughts?
Thanks
Last edited by fireguy7; 11-25-2009 at 03:20 PM.
How about
=If(A2="x",Sum(A1:E1),0)
or
=SUM(IF(A2="x",A1:E1,0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That works! Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks