Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel problem
Okay I have a speadsheet that goes like this
A b GA 76876 GA 87798 FL 56567 TN 90997 GA 78876 I need to find the total miles for GA then FL then TN. So how do I write the formula to pull the date from A and B and tell me how many mile I traveled in each state all month long? Thanks to anybody who can answer this question!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel problem
Hi
=SUMIF(A1:A100,"=GA",B1:B100) Regards, Per "Jody S" <Jody skrev i meddelelsen ... Okay I have a speadsheet that goes like this A b GA 76876 GA 87798 FL 56567 TN 90997 GA 78876 I need to find the total miles for GA then FL then TN. So how do I write the formula to pull the date from A and B and tell me how many mile I traveled in each state all month long? Thanks to anybody who can answer this question!! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel problem
Lets say you have a list of states in column C, with "GA" being in C1.
In D1: =SUMIF(A:A,C1,B:B) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jody S" wrote: Okay I have a speadsheet that goes like this A b GA 76876 GA 87798 FL 56567 TN 90997 GA 78876 I need to find the total miles for GA then FL then TN. So how do I write the formula to pull the date from A and B and tell me how many mile I traveled in each state all month long? Thanks to anybody who can answer this question!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |