Oct 05 2017
07:37 AM
- last edited on
Jul 25 2018
10:11 AM
by
TechCommunityAP
Oct 05 2017
07:37 AM
- last edited on
Jul 25 2018
10:11 AM
by
TechCommunityAP
Hi All,
I have been using Excel for a few years but am new to formulas (aside from the basic addition, subtraction, multiplication, etc.). I have a worksheet which contains dollar amounts in one column and dates in another column. The column that has the dates is completed only when the policy is issued so it has many empty rows. I need a formula that will determine which rows in the date column (column E) contain a date and take the corresponding dollar amount from the premium column (column C) and add the totals for written business. I have tried using several "IF" functions and "LOOKUP" functions but I am missing something because none of the formulas are pulling just the premiums that correlate to the dates in the written column. Can anyone please tell me what I am doing wrong. Thanks so much!
Oct 05 2017 08:01 AM
Linda,
sounds like a job for SUMIF() or SUMIFS().