Forum

Notifications
Clear all

Sum Problem

2 Posts
2 Users
0 Reactions
88 Views
(@reehan)
Posts: 31
Trusted Member
Topic starter
 

I have 10 Rows from 8 to 17.
Column F6 is the sum of D8:D17.
I want that if in column C, for example, If C12 is blank, D12 does not sum in F6.
Whether D12 is empty or not.

 
Posted : 12/01/2021 9:49 am
(@debaser)
Posts: 836
Member Moderator
 

You could use:

=SUMIF(C8:C17,"<>",D8:D17)

 
Posted : 12/01/2021 10:25 am
Share: