Hello:
Please refer to attached file.
I have numbers as shown in column C for given date.
I need formula in C16:C18 to summarize by month.
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have numbers as shown in column C for given date.
I need formula in C16:C18 to summarize by month.
Let me know if you have any questions.
Thanks.
Riz
something like this? (with PivotTable)
Formula way...
=SUMPRODUCT(--(TEXT($B$3:$B$9,"mmm")&18=B16),$C$3:$C$9)
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello:
Thanks a lot
Would appreciate if you can help me further, as i need Average in highlighted column D, attached file
Riz
Last edited by rizmomin; 07-11-2018 at 08:46 PM.
You are welcome and thanks
have a nice day
Hello:
I think i got it, Thanks
Riz
with Ave? (hope it means Average) - change SUM in PivotTable to Average
or it is : Ave Caesar!
or maybe Ave Maria?
I prefer Ancient Rome
et tu brute?
LOL maybe not contra you but per ardua ad astra
yup, gotta watch those hard stars LOL
Ave Administrator, Excelers te salutant
Hope you stood up when you did that?
Yes Sir! At attention, Sir !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks