ExcelBanter - sum if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sum if statement (https://www.excelbanter.com/excel-programming/334000-sum-if-statement.html)

Buckeye

sum if statement

How does excel recognize a blank cell. I'm using the sumif statement and
want to sum if a cell is blank?

Help!

Anne Troy[_2_]

sum if statement

=if(isblank(a1),sum....
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

"Buckeye" wrote in message
...
How does excel recognize a blank cell. I'm using the sumif statement and
want to sum if a cell is blank?

Help!

Bob Phillips[_7_]

sum if statement

=SUMPRODUCT(--(NOT(ISBLANK(A1:A20))),--(A1:A2020),A1:A20)

or

=SUMPRODUCT(--(A1:A20<""),--(A1:A2020),A1:A20)

--
HTH

Bob Phillips

"Buckeye" wrote in message
...
How does excel recognize a blank cell. I'm using the sumif statement and
want to sum if a cell is blank?

Help!

All times are GMT +1. The time now is 10:33 AM.