Re: Don't show repeated totals when not adding
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Sat, 27 Oct 2007 11:14:15 -0500
How about this to give nothing until both are filled?
=IF(COUNT(a1:a2)<2,"",a1+a2)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"FC" <FC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:6F074EBF-DCF3-49EC-88E5-E2452ED45461@xxxxxxxxxxxxxxxx
Hi, my issue is simple.
A
1 26.00 My formula adds A1+A2
A3+A4
2 4.00 and so on as I filled the even numbers.
3 30.00 In this example when I
4 2.00 have not put value in
5 32.00 A6 yet I want A7 "BLANK" too.
6
7 32.00
Thanks in advance.
.
- Prev by Date: Re: Counting Last n Rows in Expanding Table
- Next by Date: Re: Can I Make This Computation Shorter?
- Previous by thread: Re: simple but very hard question
- Next by thread: Re: Don't show repeated totals when not adding
- Index(es):
