View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blessedx3 Blessedx3 is offline
external usenet poster
 
Posts: 9
Default If statement with generic value

I have a spreadsheet for recording Board members' payments. All 4 quarters
are on one sheet with with subtotals after each quarter (cells C13, C18, C23
& C28) and a "Total Due This Quarter" in cell C31. What I want to happen in
C31 is only give the total for the current quarter. Is there a way to do
that even when I don't have a specific value in the subtotal cells?