![]() |
|
#3
|
||||
|
||||
|
I agree with Sarah. At any rate, it's unclear whether column P has numeric values or strings; perhaps you'll need
=sumif(p$4: p$39, 1, c$4:c$39) +sumif(p$4: p$39, 1, d$4:d$39) +sumif(p$4: p$39, 1, e$4:e$39) +sumif(p$4: p$39, 1, f$4:f$39) +sumif(p$4: p$39, 1, g$4:g$39) +sumif(p$4: p$39, 1, h$4:h$39) +sumif(p$4: p$39, 1, i$4:i$39) +sumif(p$4: p$39, 1, j$4:j$39) +sumif(p$4: p$39, 1, k$4:k$39) +sumif(p$4: p$39, 1, l$4:l$39) +sumif(p$4: p$39, 1, m$4:m$39) +sumif(p$4: p$39, 1, n$4:n$39) +sumif(p$4: p$39, 1, o$4: O$39) I'm unclear how to selectively suppress emoticons, but the left side of each above is : and P without a space and the last item on the right is : and O with no space
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cell equals zero or another cell in IF statement | dirtboy | Excel | 3 | 06-20-2014 01:44 PM |
how to keep text format when adding new cells?
|
hotmud | Word Tables | 1 | 09-29-2013 06:12 PM |
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Using (adding) different cells
|
geoff | Excel | 3 | 11-23-2011 01:20 AM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |