Anyone know spreadsheet formulas?

[Myka]

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!

[WarDog]

You need to talk to Greggzz4. He invented Microsoft Excel.

[Myka]

Originally Posted by WarDog

You need to talk to Greggzz4. He invented Microsoft Excel.

Wow!

Hopefully he will stop in to me then, please Greg!

[mrhasan]

-------------A------------B--------------C-------------D------------E
1----------1000----------1500----------500-----------X---------- NULL

2----------1000----------1250----------250----------NULL----------X

3----------1000----------1500----------500----------NULL----------X

4-------------------------------------------------------500----------750


Formula for column D4 =SUMIF(D1: D3,"X",C1:C3) [select the space, it was become so I had to put in the space)
Formula for column E4 =SUMIF(E1:E3,"X",C1:C3)

Whatever you put in the braces must match exactly with the string you are using (X in here) or else it won't work. HTH

[Myka]

Originally Posted by mrhasan

-------------A------------B--------------C-------------D------------E
1----------1000----------1500----------500-----------X---------- NULL

2----------1000----------1250----------250----------NULL----------X

3----------1000----------1500----------500----------NULL----------X

4-------------------------------------------------------500----------750


Formula for column D4 =SUMIF(D1: D3,"X",C1:C3) [select the space, it was become so I had to put in the space)
Formula for column E4 =SUMIF(E1:E3,"X",C1:C3)

Whatever you put in the braces must match exactly with the string you are using (X in here) or else it won't work. HTH

THANK YOU!!! I was so close! I was screwing doing it like this:

Formula for column E4 =SUMIF(C1:C3,"X",E1:E3)

[mrhasan]

Originally Posted by Myka

THANK YOU!!! I was so close! I was screwing doing it like this:

Formula for column E4 =SUMIF(C1:C3,"X",E1:E3)

Glad I could be of help

The same thing can be achieved by various other functions. Lookup is another one they gives you more flexibility but can get a bit complicated so if you like, you can try lookup too. Youtube has great tutorials.

[Myka]

[edit:nevermind]