To Sum Up

D

deepak

Dear All,

Suppose column A and B have the following data:
A B
N 10
Y 8
Y 4
N 7
Y 12
Y 5

Please help me to calculate the total from column B separately for all Y's
and N's, that is, in column C the total should be 17 (as A1 & A4 have N) and
in column D the total is 29 (as A2, A3 A5 & A6 have Y)
Thank you
 
J

John Moore

In col C =if(A1="N",B1,"") , in Col D =if(A1="Y",B1,""), copy both formulas
down the range of your data and sum each at the bottom.
 

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

To Sum Up 2
Sum 2
2 level subtotal result weird 2
Sum Totals/Different Conditions 3
question for excel how to have linked sum in column? 1
COUNTIF between dates and if value = "y" 8
Formula Question 2
% of subtotal in pivot table 1

Top