I have a formula to get the flight time each month I exported my sheet to excel and I see there is no =ArrayFormula I tried removing the ArrayFormula and hitting ctrl shift enter but no luck and some help me with the conversion to excel
=ArrayFormula(sum(iferror((month('DATA ENTRY'!A$6:A$100)=month("1-"&B22))*'DATA ENTRY'!F$6:F$100)))
Maybe this...
=SUMPRODUCT(--(MONTH('DATA ENTRY'!A$6:A$100)=MONTH("1-"&B22)),'DATA ENTRY'!F$6:F$100)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tony I'm getting a Value! now i'll attach sheet so you can see what i'm trying to do this sheet is used to take flight time and convert it to tenths and add it to totals like engine time etc..
The entries in column A of the Data Entry sheet are not true Excel dates even though they may look like dates. They're TEXT strings that look like dates.
Here's what I had to do to convert them to true Excel dates...
Select the "dates" in column A
Goto the Data tab
Select Text to Columns
Click Next twice
In Step 3 of the userform, under Column Data Format, select Date and in the drop down list select DMY
Click Finish
Thanks Tony
You're welcome!
Sorry messed up formula again
something is weird about my formatting on the A6 thru A9 but working now once I entered data in those cells on sheets N46E & 46F
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks