F
franko
Can anyone help??
I am trying to get sales data for each month from a worksheet and total it.
e.g I have ColumnA=Month, ColumnB=Transaction type, ColumnC= Amount
What i am trying to do is sum the values of column C but only if column A=
"JANUARY" ...... but ..... i also do not want the total if Column B =
"invoice", regardless of it being in Jan
i.e. the totals for jan and not invoice.
Any ideas on how to expand the criteria cus it seems beyond me!!
So far i have:
=SUMIF(Worksheet!$A$6:$A$1000,"JANUARY",Worksheet!$C$6:$C$1000)
I hope it is possible and thanks for trying
I am trying to get sales data for each month from a worksheet and total it.
e.g I have ColumnA=Month, ColumnB=Transaction type, ColumnC= Amount
What i am trying to do is sum the values of column C but only if column A=
"JANUARY" ...... but ..... i also do not want the total if Column B =
"invoice", regardless of it being in Jan
i.e. the totals for jan and not invoice.
Any ideas on how to expand the criteria cus it seems beyond me!!
So far i have:
=SUMIF(Worksheet!$A$6:$A$1000,"JANUARY",Worksheet!$C$6:$C$1000)
I hope it is possible and thanks for trying