Count if another cell is blank

caz46 · #1 10-30-2015, 04:47 AM

Hello,

I have a spreadsheet with a running total and would like to count a sum only if there is an invoice number to the right of the cell.

I have attached the worksheet for you to see what I have created.

I also am having trouble grouping each month, I have subtotalled but although the calculations are correct, when I try to reduce the months down to just the total per month, it does not reduce all the dates.

I would appreciate your help. If I am only meant to ask one question per post, the first is priority.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
How do you count how often a specific value occurs in single changing cell?	blackjack	Excel	12	09-03-2014 10:41 AM
compare, match and count cell contents between sheets	bobsone1	Excel	11	08-07-2014 10:34 PM
won't show blank cell	bhum	Excel	2	01-28-2014 02:34 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM