I am trying to work on a report in office and i am stuck.
The requirement is as shown below.
A B C D E F
150 0 10 10 10 180
0 180 10 10 10 210
180 0 10 10 10 210
0 190 10 10 10 220
200 0 10 10 10 230
Note : In A & B columns, if there is a value in one then the second will always be zero.
Column F denotes the sum of A to E
The requirement is:
I want the total Sum of only those values which have zero in coulmn A. i.e. the result should come as (210+220)
Please help me out with this.
Last edited by vaibhavjain; 04-28-2011 at 08:42 AM.
Hi Vaibhavjan,
Hope this will work for you.. in cell F1 apply this formula =IF(A1=0,SUM(A1:E1),0)
Thanks
Use
=SUMIF(A:A,0,F:F)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
vaibhavjain 
Register To Reply
Bookmarks