Forum Discussion
Adding numbers based on font size
I have a list of bond payments. The ones that come in on the first of the month are in font size 10....the ones that pay on the 15th are in font size 12. Is there a way for me to create a formula tha...
Not without using vba to write a procedure (or a user defined function that you could use in the worksheet).
Could you use a conditional sum function to test the day of the date and sum amounts based on whether it is 1 or 15?
Say the date is in column A and the amount is in B:
=SUMPRODUCT(--(DAY(A1:A10)=1),B1:B10)
=SUMPRODUCT(--(DAY(A1:A10)=15),B1:B10)
Could you use a conditional sum function to test the day of the date and sum amounts based on whether it is 1 or 15?
Say the date is in column A and the amount is in B:
=SUMPRODUCT(--(DAY(A1:A10)=1),B1:B10)
=SUMPRODUCT(--(DAY(A1:A10)=15),B1:B10)