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!! |
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!! |
All times are GMT +1. The time now is 01:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com