Home

I need a (complicated?) formula

Highlighted
Linda Humphries
New Contributor

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! 

2 Replies

Linda,

 

sounds like a job for SUMIF() or SUMIFS().

Thanks. I will keep trying!
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies