View Single Post
  #1  
Old 04-17-2016, 06:23 PM
Myka's Avatar
Myka Myka is offline
Moderator
 
Join Date: Mar 2004
Location: Saskatoon, SK.
Posts: 11,268
Myka will become famous soon enough
Default Anyone know spreadsheet formulas?

I'm trying to figure out how to get a spread sheet to do this...

------------A-----B--------C---------D----------E------
----------Start | End | Column T | Column B | Column P--

1---------1000--1500----500---------X-------(blank)---
2---------1000--1250----250-------(blank)------X------
3---------1000--1500----500-------(blank)------X------
4
5--Total-----------------------------500-------750-----


So I want Column T to be Column B minus Column A. Then I want the Total at the bottom to add up all the Column T that have an X under the Good column, and then add up all the Column T that have an X under the Bad column. I hope this makes sense. I know how to get the formula for Column B minus Column A equals Column T. It's the second part that has me stumped.

Please help!
__________________
~ Mindy

SPS fanatic.


Last edited by Myka; 04-17-2016 at 07:41 PM.
Reply With Quote