Thread: Microsoft excel equations
View Single Post
Old 9th-April-2006, 04:19 PM   #6 (permalink)
TheTramp
The Forum Legend
 
TheTramp's Avatar
 
Join Date: Nov 2002
Location: Dundee, Scotland
Posts: 10,470
Rep Power: 6
Reputation Total: 1692
TheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to all
Re: Microsoft excel equations
Okie...

So, there are probably better ways to do it. But, I'd have 2 more columns (probably hidden).

So:

22 | p | =IF(B1="p", A1,0) | =IF(B1="n",A1,0)
33 | p | =IF(B2="p", A2,0) | =IF(B2="n",A2,0)
..
55 | n | =IF(B5="p", A5,0) | =IF(B5="n",A5,0)
..

Then, you can sum both rows independantly.....

Does this make sense?

I can send you an example if you want.
TheTramp is offline   Reply With Quote