Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I think I should use Sumif
I am creating a summary page. I do not want to use a pivot table for several
reasons. I would like to add all data from Q7:Q9999 (on the "Data" Sheet) only when the value in AE7:AE9999 (on the "Data" sheet) = C1 (on the "Monthly Summary" sheet) This will allow the user to type in a certain Year and month and pull all credit dollars issued for that month. Right now I have the below for a formula, but it is not working. Where am I going wrong? =SUMIF(Data!Q7:Q9999,Data!AE7:AE9999='Monthly Summary'!C1) There should be a value to this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I think I should use Sumif
=SUMIF(Data!AE7:AE9999,'Monthly Summary'!C1,Data!Q7:Q9999)
-- Regards, Peo Sjoblom "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... I am creating a summary page. I do not want to use a pivot table for several reasons. I would like to add all data from Q7:Q9999 (on the "Data" Sheet) only when the value in AE7:AE9999 (on the "Data" sheet) = C1 (on the "Monthly Summary" sheet) This will allow the user to type in a certain Year and month and pull all credit dollars issued for that month. Right now I have the below for a formula, but it is not working. Where am I going wrong? =SUMIF(Data!Q7:Q9999,Data!AE7:AE9999='Monthly Summary'!C1) There should be a value to this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |