ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counting Values on a condition (https://www.excelbanter.com/excel-worksheet-functions/37217-counting-values-condition.html)

madeforidiots

Counting Values on a condition
 
I currently have a spreadsheet for monitoring my mobile phone calls.

What I want to be able to do is show values for what numbers i'm making what
kind of communications, ie, i want to show in the spreadsheet how many calls
i've made to a number, but also the number of texts and/or picture messages
that have been sent too.

Is there anything that can be formulated to show this as I cannot find
anything on the Help site.

madeforidiots

Govind

Hi,

Creating an excel pivot table would be appropriate for your requirements.

Regards

Govind.

madeforidiots wrote:
I currently have a spreadsheet for monitoring my mobile phone calls.

What I want to be able to do is show values for what numbers i'm making what
kind of communications, ie, i want to show in the spreadsheet how many calls
i've made to a number, but also the number of texts and/or picture messages
that have been sent too.

Is there anything that can be formulated to show this as I cannot find
anything on the Help site.

madeforidiots



All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com