Sum Problem

General Excel Questions & Answers

Last Post by Velouria 4 years ago

2 Posts

2 Users

0 Reactions

12 Views

RSS

Reehan Saeed

(@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

Velouria

(@debaser)

Posts: 834

Member Moderator

You could use:

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

Posted : 12/01/2021 10:25 am

26 Forums
7,176 Topics
31.5 K Posts
7 Online
34.8 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed